--- title: "Another free Postgres hosting option arrives" publication: "Postgres Weekly" issue: 621 published_at: "2025-10-23" canonical_url: "https://postgresweekly.com/issues/621" --- Plus calculating the read and write ratio of your tables. | #​621 β€” October 23, 2025 [Web Version](https://postgresweekly.com/issues/621) Together with [![TigerData logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_1280,h_296/e_make_transparent/co_white,e_outline:30/ri3mjutb8cydvqo9zn6r.png)](https://www.tigerdata.com/blog/tiger-lake-a-new-architecture-for-real-time-analytical-systems-and-agents/?utm_source=cooperpress&utm_medium=referral&utm_campaign=project-eyeballs-2025&utm_content=postgres-weekly-newsletter-tigerlake-1) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/zktpbzsf69swswdqb4nc.jpg)](https://www.crunchydata.com/blog/is-postgres-read-heavy-or-write-heavy-and-why-should-you-care) [Is Your Database Read Heavy or Write Heavy?](https://www.crunchydata.com/blog/is-postgres-read-heavy-or-write-heavy-and-why-should-you-care) β€” Most databases will tend to be heavier on reads than writes, but it depends on your workload. Is it worth knowing for sure? When it comes to tuning, yes. David shows off an epic SQL query to figure out the read:write ratio for your tables. David and Elizabeth Christensen πŸ’‘ The query in the post above works fine, but if you want to also include tables that are read-or-write _only_, change the `AND` on line 19 to `OR`. [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/43c34af4.png)](https://www.tigerdata.com/blog/tiger-lake-a-new-architecture-for-real-time-analytical-systems-and-agents/?utm_source=cooperpress&utm_medium=referral&utm_campaign=project-eyeballs-2025&utm_content=postgres-weekly-newsletter-tigerlake-1) [Tiger Lake: Bridging Postgres and The Lakehouse](https://www.tigerdata.com/blog/tiger-lake-a-new-architecture-for-real-time-analytical-systems-and-agents/?utm_source=cooperpress&utm_medium=referral&utm_campaign=project-eyeballs-2025&utm_content=postgres-weekly-newsletter-tigerlake-1) β€” Tiger Lake unifies Postgres with your lakehouse in real time. No pipelines, no orchestration. Stream, analyze, and serve data continuously using open formats. Build dashboards, agents, and analytics powered by one integrated, Postgres-native architecture. TigerData sponsor [Tiger Data Introduces a Free Postgres Plan](https://www.tigerdata.com/blog/introducing-agentic-postgres-free-plan-experiment-ai-on-postgres) β€” Tiger Data, formerly Timescale, has offered a Postgres platform for some time now, but never a free tier. Now you can get up to two services for free with up to 750MB storage on each. The pitch is being made towards AI and agent developers, due to the state of the industry right now, but could be used by anyone for small projects or experiments. TigerData πŸ’‘ Other providers like [Aiven](https://aiven.io/free-postgresql-database), [Neon](https://neon.com/pricing) and [Supabase](https://supabase.com/pricing) offer similar free tiers. πŸ”Ž [Hybrid Search in Postgres: The Missing Manual](https://www.paradedb.com/blog/hybrid-search-in-postgresql-the-missing-manual) β€” An explanation of how full text search with BM25 scoring (powered by [ParadeDB](https://github.com/paradedb/paradedb)) coupled with vector similarity search (powered by `pgvector`) trumps Postgres’s native full text search when it comes to relevance ranking. James Blackwood-Sewell [The Benefits of a `DESC`ending Index](https://www.cybertec-postgresql.com/en/benefits-of-a-descending-index/) β€” _β€œThe well-known use case for the DESC clause in an index definition is support for a mixed ORDER BY clause. But there are corner cases in which PostgreSQL can populate a descending index more space-efficiently, and a forward scan on a descending index can perform better than a backward scan on an ascending index.”_ Laurenz Albe β–Ά[14x Faster with 12x Less Compute: Sometimes Postgres Really is All You Need](https://www.youtube.com/watch?v=OVecyUF1W0A) β€” How James’ team went from an unreliable 12 server HBase/OpenTSDB cluster to two servers with 100% uptime with Postgres/Timescale for its time series workload. James Udiljak πŸ“„ [Getting a Portable Setup for Postgres 18 on Windows](https://notepad.onghu.com/2025/portable-postgresql-on-windows-without-installation-pg18/) – A handy walkthrough. Mohit Sindhwani πŸ“Ί [Proper Postgres Parameters to Prevent Poor Performance](https://www.youtube.com/watch?v=CYJvZJP_lZA) – An hour-long webinar recording. Greg Dostatni πŸ“„ [PostGIS Performance: `pg_stat_statements` and Postgres Tuning](https://www.crunchydata.com/blog/postgis-performance-postgres-tuning) Paul Ramsey **RELEASES AND CODE:** [NoraSearch: Extension to Quickly Find Substring Match Offsets and Counts](https://github.com/lemmerelassal/NoraSearch) β€” For example, searching for `'abra'` in `'abracadabra'` would return `{{0,4},{7,4}}`. The author cites one use case as being for analyzing DNA sequences. Lemmer EL ASSAL [pg_ivm 1.13: Incremental View Maintenance (IVM) Extension](https://github.com/sraoss/pg_ivm/releases/tag/v1.13) β€” A more efficient way to update materialized views incrementally, applying only changes instead of fully recomputing the view like `REFRESH MATERIALIZED VIEW` does. v1.13 adds support for outer joins. IVM Development Group [PL/Haskell 5.0: Use Haskell in Your SQL Functions](https://github.com/ed-o-saurus/PLHaskell) β€” Haskell is a _functional_ language rather than a procedural one, but you can nonetheless use it to define procedures in a way Postgres can work with. v5 adds support for date and time types. Edward F. Behn, Jr. - [pgwire 0.34](https://github.com/sunng87/pgwire) – The Postgres wire protocol implemented in a Rust library. - [pg_dbms_errlog v2.2](https://github.com/HexaCluster/pg_dbms_errlog) – Extension to emulate Oracle's `DBMS_ERRLOG`. - [postgres-meta 0.93](https://github.com/supabase/postgres-meta) – A RESTful API for managing Postgres. - [Squawk 2.29](https://github.com/sbdchd/squawk) – Linter for Postgres migrations and SQL. - [pgAdmin 4 v9.9](https://www.pgadmin.org/docs/pgadmin4/9.9/release_notes_9_9.html) – Popular Postgres admin tool. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).