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

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

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

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

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