Postgres 18.2, 17.8, 16.12, 15.16, and 14.21 Released, But..! — Every maintained release line of Postgres has received an update to both fix a variety of bugs as well as five security issues covering oidvector, intarray, pgcrypto, pg_trgm, and a multibyte character length validation issue that can result in a buffer overrun. However, look at the note below before you upgrade.

PostgreSQL Global Development Group

That Analytics Database Was Supposed to Be Temporary — Now it has its own pipelines, its own schema, its own problems. TimescaleDB extends Postgres so analytics runs on live data—no second system needed. Hypertables, 95% compression, continuous aggregates. Start building for free.

Tiger Data (creators of TimescaleDB) sponsor

Read Efficiency Issues in Postgres Queries — A walkthrough of two causes of slow queries: heap/index bloat and the less commonly discussed issue of data locality. Includes working examples, buffer counts, and before/after query plans showing the impact and how to fix it.

Michael Christofides

Bluebox Docker: A Living Postgres Sample Database — Bluebox is a sample database for exploring Postgres features with non-trivial data. Bluebox Docker provides container images with the dataset preloaded across all major Postgres versions, plus pg_cron jobs that continuously update data for testing vacuuming, bloat, index usage monitoring, etc.

Ryan Booz

Materialized Views: When Caching Your Query Results Makes Sense (And When It Doesn't) — Materialized views aren’t complicated, but using them well takes care. This guide digs into the operational stuff that matters, with a concrete example taking a 28-second query down to 180ms through precomputed aggregations.

Umair Shahid

pg_background: Run SQL in the Background, Independent of Your Session — An extension to execute SQL commands asynchronously in the background. Handy if you want to return to the client quickly, while letting Postgres crunch away on things. Unlike something like pg_cron, this is for on-demand rather than scheduled tasks.

Vibhor Kumar

Citus 14 Released with Postgres 18 Support — The open-source extension (now maintained by Microsoft) that enables horizontal scaling by sharding tables across multiple nodes now supports Postgres 18, along with its improvements such as async I/O, virtual generated columns, OAuth support, and more.

Mehmet Yilmaz (Microsoft)

pg_stat_ch: An Extension That Exports Every Metric to ClickHouse — Turns every query execution into a fixed-size ~4.6KB event and streams them into ClickHouse.

Kaushik Iska (ClickHouse)