PostgreSQL: Repack, Vacuum and Replication Hardening
Today's activity centers on backpatched reliability fixes for concurrent repack, parallel autovacuum, and sequence synchronization, plus a JSON_TABLE revert for dump and upgrade safety. Internal cleanup of invalidation counters, TOAST headers, and catalog definitions rounds out the changes.
Duration: PT2M30S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-09-25T13:04:43Z
- Audio duration: PT2M30S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Hello, it's Friday, September 25th, 2026, and this is your PostgreSQL developer briefing.
The through-line today is small correctness and hardening fixes with outsized reliability impact, plus steady internal cleanup.
First, table maintenance and upgrade safety. Commit 45da2c1 fixes concurrent repack when a column was added without a table rewrite. The concurrent apply step was decoding tuples with the wrong descriptor, losing default values, breaking replica identity lookups, and risking a crash in comparison. It now uses the…
Second, logical replication hardening. Commit 7a7f606 adds a range check on the sequence position sent back by the publisher during sequence synchronization. Without it, a malicious or buggy remote could steer a memory access past the end of the worker's list. The index is now also received as a 32-bit integer to…
Third, internals modernization and build hygiene. Commits 25217d9 and df3978c convert the shared invalidation message counter to unsigned and then to an atomic, removing a spinlock used only for memory barriers. Commit e27f3b2 removes a duplicate definition for the compressed toast header, with no behavior change.…
What's next: expect verification…
Nearby episodes from PostgreSQL
- Snapshot and Visibility Map Correctness
- Concurrency Race Fixes and Replay Relief
- Upgrade Check and Error Code Cleanup
- Simplified Hashing for Sort Estimates
- Weekly Recap - Planner Correctness, Conflict Safety and JSON Fixes
- JSON_TABLE Error Cascade, Join Fix and Test Flakiness
- Correctness Fixes Across Planner, Replication, and Foreign Keys
- Correctness Fixes Land Ahead of Version 19