Postgres 19 Beta 4 Released — Confirming recent developments, the latest beta is largely about what’s been removed, although numerous fixes have also made it in. A release candidate is due in the next couple of weeks, with the final release possibly in October if things go well.

PostgreSQL Global Development Group

SELECT count(*) Shouldn't Take Eight Seconds — A count or a rollup over millions of rows crawls, so you add indexes, a read replica, a nightly job. TimescaleDB extends the Postgres you already run so those queries return in milliseconds on live data. No warehouse. Get $1000 credit to start.

Tiger Data (creators of TimescaleDB) sponsor

What REPACK (CONCURRENTLY) Costs While It Runs — A measurement of Postgres 19's new online table rewrite against pg_repack and pg_squeeze. REPACK was fastest, but has some downsides to consider.

Radim Marek

Can Your Postgres Survive a Bad Query? — ClickHouse compares what happens on four Postgres cloud providers (itself included) when queries eat all the RAM, and explains why setting work_mem doesn’t prevent it.

Kevin Biju (ClickHouse)

Safe Not Safe: Is My Migration Safe? — A fun side project from a former lead of Cloudflare's Postgres platform team, who spent years reviewing other teams' migrations. Paste in a SQL migration and it flags common problems, parsing entirely in the browser using Postgres's own SQL parser via WASM.

Vignesh Ravichandran

Kafgres 0.2: 700 MB/s of Kafka Throughput on Postgres — We featured this Kafka-compatible broker that runs inside Postgres a few weeks ago. Its author has since taken it from 113 MB/s to 700 MB/s write throughput on a single box.

Raynor Elgie

'We Ported the Original Doom to SQL' — Not quite Postgres, but a fun project from the team behind the Postgres-compatible CedarDB. It takes 1993's pioneering FPS and runs the logic and renderer in SQL, returning each frame as a bitmap for Python to show. Some neat architectural details (the renderer uses 89 CTEs!) and SQL queries here.

Lukas Vogel (CedarDB)