PostgreSQL: Vacuum Visibility and Reliability Fixes
Vacuum operations gain per-index progress reporting and a fix for stale autovacuum cost delays, while replication conflict handling, pg_dump, and FETCH protocol handling get targeted reliability fixes.
Duration: PT2M24S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-10-02T13:04:11Z
- Audio duration: PT2M24S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Hello, and welcome to your PostgreSQL briefing for October 2nd, 2026.
The lead today is operational confidence. Vacuum becomes more observable and better behaved under parallel load, alongside fixes for silent backup, replication, and crash risks.
First, vacuum monitoring and control. A change tracked as commit 1378aa1 adds per-index progress to the vacuum progress view, with three new fields showing which index is currently being cleaned, how many blocks remain in total, and how many are done. That matters because index cleanup can dominate a long vacuum,…
Second, three correctness fixes with direct developer impact. For logical replication, sequential scans for deleted rows will now use the index recorded in the relation map, rather than re-looking it up. That prevents a concurrent index drop from shifting the comparison to the full row and misreporting a conflict as…
Finally, brief tooling cleanup. Three commits adjust compiler attribute placement for C 23 correctness and improve the code formatter's handling of alignment annotations.
What's next: expect a catalog version bump on main from the progress view change, update any monitoring queries, and watch for a follow-up…
Nearby episodes from PostgreSQL
- Time Zone Update and Build Reliability Fixes
- Row Security and Replication Safeguards
- Repack Data Loss Fix and Test Stability
- Replication Race, Lock Timing, and Log Cleanup
- Weekly Recap - Hardening Privileges and Edge-Case Reliability
- pg_dump Tar Restore Fix
- Privilege Fixes and Stats Restore Repairs
- Repack, Vacuum and Replication Hardening