#​645 — April 22, 2026

Web Version
Together with  Tiger Data logo

Postgres Weekly

📝 The First Draft of the PostgreSQL 19 Release Notes — Bruce has just completed the first, bulletpoint-heavy draft of the release notes for Postgres 19, targeted to land this September with a beta expected in the coming months.

Bruce Momjian

💡If you fancy seeing the process behind the notes, Bruce made this wiki page.

Your Hot Table Hit a Billion Rows. Now What? — TimescaleDB chunks growing tables automatically, compresses cold data up to 95%, and pre-computes rollups with continuous aggregates. All in native Postgres. No new query language, no second database, no migration. Start building for free.

Tiger Data (creators of TimescaleDB) sponsor

Introducing Xata OSS: A Postgres Platform with Branching, Now Apache 2.0 — Xata has made the core technology of its Postgres platform open source. You get copy-on-write branching at the storage layer that clones databases in seconds, scale-to-zero for inactive branches, while still having standard Postgres underneath.

Tudor Golubenco / Xata

IN BRIEF:

📉 Investigating the Linux 7.0 Postgres Throughput Regression — We recently featured an article about how Linux 7.0 was affecting Postgres performance on certain setups. Lætitia digs into what the actual issue is, who’s affected (very few of us!) and what to keep in mind when you upgrade.

Lætitia Avrot

How CTIDs Gave Me a 30x Speedup on Processing 200 Million Rows — A look at where index scans can fail at scale on large static tables, how the internal ctid (physical row address) enables true sequential I/O, and a full implementation with visualizations of the access pattern difference.

Connor Hallman

When Upserts Don't Update But Still Write — How Datadog traced doubled disk writes and quadrupled WAL syncs to a surprising behavior: ON CONFLICT DO UPDATE locks the conflicting row even when the WHERE condition means nothing is actually updated.

Anthonin Bonnefoy (Datadog)

📄 Using Non-ACID Storage as a Workaround for a Lack of Autonomous Transactions Pavel Stehule

📄 Waiting for Postgres 19: Online Enabling and Disabling of Data Checksums Hubert Lubaczewski

📄 Finding Invisible Use-After-Free Bugs in the Postgres Planner Andrei Lepikhov

📰 Classifieds

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

Collect real-time search data at scale with an API built for analysts, engineers, and AI teams.

RELEASES AND CODE:

PgQue: A Pure SQL + PL/pgSQL Zero-Bloat Postgres Queue — From a long-time Postgres contributor comes a modern version of Skype’s PgQ in ‘one SQL file + pg_cron’ form. Architecturally closer to Kafka than a typical job queue with zero event-table bloat, native fan-out, and no SKIP LOCKED.

Nikolay Samokhvalov

💡 PgQue attracted some discussion on Hacker News where Nikolay answered a variety of questions.

Apache Cloudberry 2.1: A Postgres-Based MPP Database — An MPP (Massively Parallel Processing) database splits data and query execution across many nodes; a big win for analytics workloads. Cloudberry carries on work started with Greenplum, but on a more modern Postgres kernel. GitHub repo.

Apache Software Foundation

🔥 pg_roast: An Extension That Audits and 'Roasts' Your Database — Built upon principles from the book PostgreSQL Mistakes and How to Avoid Them.

Samir Ketema

  • 🔎 pg-index-health-sql 0.40 – SQL queries for analyzing & maintaining indexes and tables. pg-index-health 0.40 is the same, but as a Java library.

  • credcheck 4.7 – Extension that validates credentials during user creation or renaming and password changes.

  • pgwire 0.39 – The Postgres wire protocol as a Rust library for writing Postgres-compatible servers and clients.

  • PostgREST 14.10 – Serve up a fully RESTful API from a Postgres database.

  • River 0.35 – Robust job processing system for Go using Postgres.

  • PgDoorman 3.5 – Multithreaded connection pooler built in Rust.