Postgres Weekly

Postgres 19's bumpy road to release

Wed, 23 Sep 2026 00:00:00 +0000

#666 — September 23, 2026

Postgres Weekly

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)

💡 Beta 4 is expected tomorrow (September 24). This draft release announcement lists the reverts, and a release candidate should follow in early October.

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

In Brief

🔎 PlanetScale has launched TIN, a fast BM25 full-text search index for Postgres. It's closed source and PlanetScale-only, though they do offer Lead, an open source "slow but correct substitute" for testing TIN queries locally.
🎧 Over on Talking Postgres, Claire Giordano spoke with Peter Eisentraut about his 25 years of contributing to Postgres, which began with psql tab completion.
🇨🇦 PGConf.dev 2027 takes place May 11–14 in Montréal. Registration is open. It's always popular and you can watch 📺 this year's talks here.
Google has previewed native BM25 search in AlloyDB and Cloud SQL, built atop the pg_textsearch extension.

⚙️ Operations & Performance

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)

📄 Where Postgres Stores Row Locks – Every row lock ends up as a write to the heap page, as revealed by pageinspect. Radim Marek

🛠️ Tools and Releases

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)

TimescaleDB 2.30 – Tiger Data's time-series extension makes ORDER BY ... LIMIT queries fast even on hypertables with huge numbers of chunks.
PostgreSQL Anonymizer 3.2 – Dalibo's data masking extension adds faster pseudonymization functions and includes fixes for 3 critical vulnerabilities.
pgAdmin 4 v9.18 – The popular Postgres management tool.

📰 Classifieds

🚀 Triple your Postgres productivity. pgEdge AI DBA Workbench: AI monitoring & diagnostics for ANY Postgres v14+. Open source.

🎟️ Join us at Supabase Select on October 2. Learn from the industry’s best builders and meet people building developer tools. Apply to attend with 25% off: SUPAWEEKLY.

And Finally…

🤖 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

Tom Lane on threads, MVCC and 30 years of Postgres

Wed, 16 Sep 2026 00:00:00 +0000

#665 — September 16, 2026

Web Version

Postgres Weekly

Tom Lane on 30 Years of Postgres Architecture — The hugely prolific Postgres core team member (who also co-wrote the original PNG spec!) tackles a lot here, including why Postgres uses processes rather than threads, reliability, MVCC, and how v13 was his least favorite version. There's also ▶️ an hour-long video of the entire interview.

Elizabeth Garrett Christensen and Tom Lane

Render Runs Postgres Alongside Your Apps — Spin up a production-ready Postgres database in seconds. Connect from web services, background workers, and agent workflows over a private network, all on one platform. Manage backups, scaling, and high availability without the operational overhead. Start free and scale from there.

Render sponsor

The Lifecycle of a Sharded Postgres Query — PlanetScale has launched Neki, a sharded Postgres system where a router speaks the wire protocol and plans queries across shards of standard Postgres servers. This illustrated walkthrough is the more interesting read, though.

PlanetScale Team

💡 PlanetScale is 'undecided' as to whether Neki will be open sourced. Citus is the established open-source distributed Postgres option, taking a more integrated extension-based approach instead.

IN BRIEF:

postgres-contrib.org now has a submissions form for telling them about non-code Postgres contributions (talks, meetups, translations, reviews, mentoring). No account or email is needed.
🇨🇳 你会说中文吗？Ruohang Feng has unveiled pgsql.cc, a Chinese-language Postgres site with full Chinese documentation for 11 versions.
🇨🇭 CERN PGDay 2027 takes place on February 12, 2027 at CERN in Geneva. A CFP is open until November 8.
🇪🇺 PGConf.EU 2026 is only a month away on October 20–22 in Valencia, Spain.

Plan Advice in Postgres 19 — Two new modules, pg_plan_advice and pg_stash_advice, let you capture planner advice, selectively enforce it, and apply advice automatically by query ID. Dimitri shows off the workflow.

Dimitri Fontaine

The Unbearable Lightness of 'One More Index' — Adding an index to tackle a problem on a hot table can seem sensible, but the costs can quickly rack up as they accumulate. This post looks at the tradeoffs involved and how to assess them.

Radim Marek

📊 Postgres Development Activity Over 28 Years — Armed with charts, Tomas shows how the pgsql-hackers list has got much busier over time, while commits and insertions/deletions have been slowly and steadily growing.

Tomas Vondra

Troubleshooting Row Lock Contention in Amazon Aurora PostgreSQL — How to trace row lock contention with built-in views, pgrowlocks, and lock-wait logging. Part two covers using AWS's tooling to locate the contention, then explores ways to fix it.

Kumar and Manivasakan (Amazon)

📄 Optimizing Aggregates: What Can an Extension Do? – Using Postgres 19's new planner hook to prototype stripping a needless sort from SUM(x ORDER BY x). Andrei Lepikhov

📰 Classifieds

🎟️ Join us at Supabase Select and learn how we’re building the next generation operating system for Postgres with Multigres. Apply to attend with 25% off: SUPAWEEKLY.

🧊 Paying SSD prices for data nobody reads? ColdFront tiers old Postgres rows to S3 automatically, the open source way.

RELEASES AND CODE:

pgrust 0.3: A Rust Rewrite of Postgres, Now Ready to Try — A noteworthy milestone for a Rust reimplementation of Postgres that you're invited to try on real world workloads (in a non-critical environment!). v0.3 now tracks Postgres 18.6 and focuses on reliability. There's also a browser-based demo so you can kick the tires without installing it. GitHub repo.

Michael Malis

WalShadow: Replicating Postgres to ClickHouse from Physical WAL — A new open-source engine to replicate Postgres data into ClickHouse without logical decoding. ClickHouse reports ~200ms commit-to-visible latency.

Sai Srirampur (ClickHouse)

PostgreSQL Migrator 1.0: Migrate Oracle and MySQL to Postgres — A single-binary tool for migrating Oracle and MySQL/MariaDB databases, with a web UI for spotting problems and fast COPY-based data transfers.

Étienne Bersac (Dalibo)

OrioleDB beta17 – Supabase's alternative storage engine for Postgres adds CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY for btree indexes, page checksums, and cross-major pg_upgrade support.
pgstream 1.5 – CDC for Postgres that replicates DDL and schema changes too.
PostgREST 16.3 – Serve a fully RESTful API from any existing database.
pgmq 1.13.0 – The lightweight message queue extension.

Postgres 19 loses SQL/PGQ (and its release date)

Wed, 9 Sep 2026 00:00:00 +0000

#664 — September 9, 2026

Web Version

Postgres Weekly

The Scary Postgres 19 Patch Contest — It’s not even Halloween yet, but in this fascinating thread on the pgsql-hackers list Robert Haas set out with Claude to “evaluate which v19 patches were the scariest”. One of them, SQL/PGQ property graphs, has since been dropped from v19, but five remain…

Robert Haas et al.

💡 There's some more background to SQL/PGQ's removal in a separate thread on pgsql-hackers too.

Coming Soon: ParadeDB Cloud — We're building a fully managed ParadeDB: one Postgres for your application data, full-text search, vector retrieval, and aggregations. Our early access waitlist is open now.

ParadeDB sponsor

POSTGRES 19: A FOURTH BETA AND SOME HARD CHOICES:

Originally expected later this month, Postgres 19's release date is now officially TBD, with a fourth beta expected on September 24. But the 'scary patch' thread (above) shows that what's going to be in it remains an open question:

Tom Lane was "quite afraid" of SQL/PGQ two weeks before it was pulled, with fixes still under discussion that needed catalog changes: "I'd be willing to bet dinner that if we ship it in v19 there will be post-release bug discoveries that are unfixable until v20."
David Rowley argued for setting "the revert bar a bit lower this year", given a perceived reduction in developer time available. Bruce Momjian noted the volume of security/CVE fixes is having an impact here.
And Joshua Drake suggested moving the release to spring 2027, rather than removing features: "I would rather have a late 19 than all these great features and hard work gutted."

How to Optimize When You Can’t Do Anything — Hettie had a production query on a 750GB, 16 billion row table that suddenly ran slow. Creating the right index wasn’t an option (it’d take over a day) but a close look at the underlying data led to an ingenious fix.

Henrietta Dombrovskaya

IN BRIEF:

🇺🇸 The PostgreSQL@SCaLE CFP is open till November 1. The Postgres track runs April 1-2 at SCaLE 24x in Pasadena.
🇮🇳 PGConf India 2027 is back next March 2-5 in Bengaluru. The CFP is open till October 15.
Postgres's RPM repo now covers Amazon Linux 2023.

Sixteen Locks Ought to Be Enough for Anybody — Did you know that, when planning a query, Postgres takes a (weak) lock on every index on the table whether it uses them or not? This is usually fine, but until Postgres 18 this could sting once a query touched more than 16 tables and indexes combined.

Christophe Pettus

📄 Inserting State Transitions in Postgres – An append-only status table gives you full history, but two concurrent transitions can both insert. Here's how to prevent the conflicts. Thiago Araújo Silva (thoughtbot)

📄 From the Trenches: My Path Through Postgres – Twenty years of Postgres war stories, from a one-time MySQL advocate. Shaun Thomas

📄 Fix Circular Role Dependencies Before Upgrading RDS and Aurora Postgres Ravi Teja Adabala (Amazon)

📄 Postgres Calculations and the Ambiguity of NULL Christopher Winslett (Crunchy Data)

📰 Classifieds

🧊 Paying SSD prices for data nobody reads? ColdFront tiers old Postgres rows to S3 automatically, the open source way.

🎟️ Join us at Supabase Select on October 2. Get first-hand information about what's coming soon in Supabase. Apply to attend with 25% off: SUPAWEEKLY.

RELEASES AND CODE:

Kafgres: A Kafka-Compatible Broker Embedded Inside Postgres — A pgrx-powered extension that serves the Kafka wire protocol from a Postgres background worker, so standard Kafka clients can produce, consume, and rebalance consumer groups against topics stored in your database.

Raynor Elgie

chdb: An Extension for Fast Imports from S3, GCS and Azure — ClickHouse’s chDB engine, wrapped as an extension for bulk imports and exports. COPY (or CREATE TABLE) can pull Parquet, Avro, ORC, Arrow and more from S3, GCS, Azure or over HTTP. Early days, but promising.

David Wheeler (ClickHouse)

pg_hardstorage 1.4 – Featured in issue 654, Cybertec's streaming-first single Go binary backup/recovery tool has continued to mature, and 1.4 is a fix-heavy release, notably for its pgBackRest, Barman and WAL-G compatibility shims.
Ivory 2.0 – A web UI originally for operating HA Postgres clusters running under Patroni, but now with a plugin architecture for supporting systems like MongoDB and Redis too.
Barman 3.20 – EDB's backup/recovery manager adds streaming multipart uploads to Google Cloud Storage, Zstd cloud backups, and faster compressed restores.
pg_cron 1.6.8 – Adding Postgres 19 and native Windows build support.
🌐 PostGIS 3.7.0 RC2

MERGE/SPLIT PARTITION reverted again

Wed, 2 Sep 2026 00:00:00 +0000

#663 — September 2, 2026

Web Version

Postgres Weekly

Read Your Own Writes Off the Primary: WAIT FOR Measured — Last week, we shared an item explaining what Postgres 19's WAIT FOR is. Now, Radim puts it to the test: naive replica reads were stale 992 times out of 1,000 even over loopback, but WAIT FOR gets that to zero with ~1-2ms overhead.

Radim Marek

Postgres in the Agentic Era: A Forrester Fireside — Forrester's Indranil Bandyopadhyay joins EDB's Lizzy Nguyen to unpack the multimodel data-platform market: where it's heading, what convergence unlocks, and how to map your workloads before you commit. Based on The Forrester Wave, Q2 2026.

EnterpriseDB sponsor

Introducing YeSQL: Practical Postgres, One Concept at a Time — 27 free SQL lessons (located here) covering things like NULL semantics, window frames, LATERAL joins, and reading EXPLAIN results. Queries run in your browser using PGlite with no signup needed.

Dimitri Fontaine

IN BRIEF:

⭐ Postgres 19 has dropped ALTER TABLE … MERGE/SPLIT PARTITION(S) after the release team requested a revert over unresolved design issues. It's the second time the feature has been pulled (previously in Postgres 17). Fingers crossed for Postgres 20.
Tiger Data asked several industry watchers why a '40-year-old database' is still winning in the AI era.
❓ So is Postgres 30 or 40? Both! The docs' history page dates Berkeley's "POSTGRES" to 1986, which is where Tiger's 40 comes from, while the 30th birthday we noted in July marks when Postgres95 got its first public CVS server (essentially the start of the community-run project).
🇬🇧 PGDay UK 2026 takes place next week (September 8) in London. Tickets are still available.

23x Faster Inserts with UUID v7 in Postgres 18 — Switching to uuidv7() hugely cut insert times on a billion-row table (versus the previously used v1 and v4 keys), though the ALTER TABLE needed an access exclusive lock and a jittered retry loop to complete the switchover.

Andrew Atkinson

A Look into Postgres 19's Many pg_catalog Changes — pg_catalog is a valuable source of information about the structure, objects, and inner workings of your database. pg-catalog-almanac lets you look at how the catalog's structure has changed over the years, and Richard has three highlights to share.

Richard Yen

🤩 As of beta 3, Postgres 19 has the most pg_catalog changes of any recent release, adding 12 catalogs and views plus 43 columns, so this almanac could be useful!

pg_tre and pg_re2: New Options for Regexes in Postgres — Benchmarks of two new regular expression extensions against pg_trgm on a 33GB table. ClickHouse's pg_re2 wins on speed, while pg_tre offers fuzzy matching but took hours to index.

Hubert 'depesz' Lubaczewski

📄 Postgres Isn't Slow: Your Storage Is – Writeup of a POSETTE 2026 talk on benchmarking local NVMe storage vs EBS showing how network storage's latency can compound. Sai Srirampur / ClickHouse

📄 New System Views in Postgres 19 – A look at pg_stat_lock, pg_stat_recovery, pg_stat_autovacuum_scores and pg_dsm_registry_allocations. Gülçin Yıldırım Jelínek

RELEASES AND CODE:

pgterm: htop For All Your Postgres Databases — A Rust TUI with a tab per Postgres database, background health checks, and views for queries, indexes and tables. Under the hood, the diagnostics come from pgbot which we featured last week. The GitHub repo README has more info.

Alex Shapalov

pg_shmemviz: Visualize Postgres Shared Memory in Your Browser — Renders allocations, C struct fields, padding and raw bytes, reading DWARF from your own postgres binary (dev instances only). You can diff snapshots too.

Bertrand Drouvot

📊 PoWA (PostgreSQL Workload Analyzer) 5.3 — A tool for collecting and aggregating metrics from multiple instances which can then be viewed through real-time charts to help optimize your setup. v5.3 improves Postgres 19 compatibility.

PoWA Team

Doltgres 1.3 – Version-controlled Git-like database (built on top of Dolt) with Postgres wire protocol support.
Stateless Postgres Query Router (SPQR) 3.1 – Production-ready Postgres sharding solution built by Yandex Cloud.
pg_trickle 0.91.0 – Extension providing declarative stream tables with incremental view maintenance via differential dataflow.
sabiql 3.0 – TUI for browsing, querying, and editing databases atop psql.

SOME POSTGRES STATS FROM DATADOG:

The State of Postgres in 2026 — An analysis of data from Datadog's many customers running its APM and monitoring agents shows Postgres adoption keeps climbing, but only 15% of instances set statement_timeout, covering indexes make up 0.3% of all indexes, 22% of tables have a (rarely indexed!) JSONB column, pgvector is the fastest-growing non-bundled extension, and more.

Datadog

🤔 They also found Postgres backends spent 56% of sampled time idle in open transactions, apparently waiting on applications, versus just 37% doing database work.