Looking Forward to Postgres 19: Epilogue — Postgres 19 is having an eventful beta, with several headline features pulled and no release date. Shaun digs into why via the pgsql-hackers mailing list, and suggests AI-assisted review is surfacing bugs faster than committers can handle them. For the good news, Elizabeth Garrett Christensen lists what's still shipping, like parallel autovacuum and ON CONFLICT DO SELECT.

Shaun Thomas (pgEdge)

Analytics Shouldn't Mean a Second Database — A dashboard query slows as data grows, and the fix is usually a warehouse plus a pipeline: sync jobs, lag, stale copies. TimescaleDB extends the Postgres you already run, so analytics stay fast on live data. Get $1000 credit to start

Tiger Data (creators of TimescaleDB) sponsor

pgBackRest Compression: How Much CPU is a Smaller Backup Worth? — A benchmark of pgBackRest's compression algorithms and levels to find where extra CPU stops paying off in smaller backups. Spoiler: "Zstandard at a low level is the sweet spot".

Agustín Gallego (Percona)

Ten Years of Postgres Logical Replication — A tour of what each Postgres release (from 10 to 19) added to logical replication, shown through building a multi-server write setup using only core features.

Dimitri Fontaine

When Deleting Old Rows Costs More Than the Work — Some lessons for anyone with big tables where bulk deletes can cost more than the writes. DBOS's engineers share some fixes, like replacing cascading deletes with batched deletes and running manual vacuums.

Kraft and Li (DBOS)

pgcli 4.7: The Friendlier psql Now Works in Scripts Too — A popular alternative to psql for interactive work, with context-aware autocompletion, syntax highlighting, and named queries. v4.7 makes it more useful for scripting, with psql-style -c, -f and -t flags, plus -y to skip destructive command prompts.

the dbcli project

pgwrh 1.0 Alpha: Read Scaling with Sharded Replicas — An experimental extension that shards a partitioned table across read replicas, with each holding only part of the data and fetching the rest from peers. Not for production!

Michał Kłeczek

pgColumnar 1.0 Alpha 4: A Columnar Table Access Method — A columnar storage option for Postgres tables. This alpha can lay tables out along a Hilbert curve, so range filters read up to 2x fewer row groups than with Z-order.

Joshua D. Drake (Command Prompt)

🤖 Teaching a 4B Model to Write 81% Faster Query Plans — As a sabbatical project at the Recurse Center, a developer used reinforcement learning to train a small model to write pg_hint_plan hints for join-heavy benchmark queries (and, on its best runs, it beat Postgres's own plans!). An intriguing read.

Rohan Bansal