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

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)

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)