https://mydbanotebook.org/posts/pgbackrest-is-dead.-now-what/
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.
4 months ago
https://www.greptile.com/
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.
#ai code review
#ai code review tool
#pr review tool
#code review ai
#ai code review bot
#austomated code reviews
4 months ago
https://www.cybertec-postgresql.com/en/monitor-autovacuum-my-queries/
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.
4 months ago
https://thebuild.com/blog/2026/04/28/parallel-autovacuum/
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.
4 months ago
https://richyen.com/postgres/2026/04/27/bitmap_heap_scan.html
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.
4 months ago
https://arpitbhayani.me/blogs/defensive-databases/
🤖 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.
4 months ago
https://github.com/timescale/pg_textsearch/releases/tag/v1.1.0
🔎  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.
4 months ago
https://github.com/NikolayS/leandex
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.
4 months ago
https://github.com/russellromney/honker
🪿  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.
4 months ago