Eight Years of Postgres Advice, Re-Checked Against Postgres 19 — A look back at years of advice on COPY, TOAST, BRIN, covering indexes and partitioning, checking which behaviors and practices have changed over time. Per-topic tables show which version moved each needle, so it's a useful recap whatever version you're on.

Christopher Winslett (Crunchy Data)

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 18.6, 17.11, 16.15, 15.19, and 14.24 Released — Landing just a day after our last issue, a huge round of releases including fixes for 28 CVEs. It isn't a simple update for everyone, either. GIN users on Postgres 18 need to check reltuples values, while users of btree_gist and ltree may need to reindex (see the "Updating" section for full details).

PostgreSQL Global Development Group

Read Your Writes: WAIT FOR in Postgres 19 — A new SQL command (a decade in the making) that lets a session block until WAL reaches a specified position. So a read on an async replica can wait for the write it needs to see, rather than forcing every commit to wait for the standby.

Gülçin Yıldırım Jelínek (ClickHouse)

Does Anyone Run Postgres Without PgBouncer? — A survey of 20 managed providers shows nearly all bundle PgBouncer (or something similar) out of the box. So, asks Brandur, isn't it time pooling was just part of Postgres?

Brandur Leach

pg_statviz 1.2: Time Series Analysis and Visualization of Postgres Stats — An extension and utility pairing for performing time series analysis and visualization of various statistics around I/O, locks, WAL, buffer use, and more. v1.2 adds Postgres 19 support, a blocking locks analysis module, and supports using OpenAI-compatible endpoints for AI analysis of the results.

Jimmy Angelakos

pgbot: Postgres Intelligence for AI Agents and Apps — A Go-powered, single binary read-only tool that connects to a Postgres server and prints a graded health report plus what changed since the last run. Only two weeks old, so early days. GitHub repo.

Alex Shapalov