pgBackRest Is 'Dead': Now What? — The biggest Postgres story on social media is pgBackRest’s repo being archived and gaining a ‘notice of obsolescence’. David Steele hasn’t got the time to keep maintaining what is, for many shops, the de facto Postgres backup/restore/recovery tool. Lætitia does a great job of explaining the project’s significance, alternatives, and possible ways forward.

Lætitia Avrot

Catch Postgres Bugs Before Your PRs Merge — Migrations, indexes, and query changes are easy to miss in review. Greptile reviews each PR with full repo context, flags real issues, and suggests fixes that match your team. Works with GitHub and GitLab.

Greptile sponsor

My Queries to Monitor Autovacuum — An experienced Postgres consultant shares his working set of queries for keeping autovacuum honest, including a "vacuum urgency" calculation, monitoring transaction ID wraparound risk, and keeping an eye on table bloat.

Laurenz Albe (Cybertec)

Parallel Autovacuum in Postgres 19: It's Not About the CPU — Learn about Postgres 19’s new autovacuum_max_parallel_workers and autovacuum_parallel_workers settings, and why parallel autovacuum primarily benefits tables with many or expensive indexes, rather than being a general CPU usage knob.

Christophe Pettus

Understanding Bitmap Heap Scans in Postgres — A short explainer for a scan type that confuses everyone the first time it shows up in EXPLAIN. Understanding how they work can make execution plans much easier to interpret.

Richard Yen

🤖 Databases Were Not Designed for This — Databases largely respond to human-written, or at least human-considered, queries, but AI agents can violate this assumption. Arpit suggests things you can tweak to survive a new world of unexpected queries and client behavior.

Arpit Bhayani

🔎  pg_textsearch 1.1: BM25 Ranked Text Search Extension — Say hello to concurrent inserts for higher write-path performance with update-heavy workloads, the ability to set a memory usage limit (and monitor said usage), and the ability to index text[], varchar[], and bpchar[] columns directly.

Tiger Data

Leandex: A Pure SQL Way to Keep Your Indexes Lean — Nik’s PgQue was our most popular link last week, but he’s already back with a new tool. leandex is another pure-SQL 'anti-extension' project that detects index bloat and safely rebuilds indexes concurrently as appropriate.

Nik Samokhvalov

🪿  Honker: Add Postgres NOTIFY/LISTEN Semantics to SQLite — Brings NOTIFY/LISTEN-style event delivery to SQLite with low latency and cross-process communication, without needing a separate daemon or broker.

Russell Romney