PostgreSQL: Replication Race, Lock Timing, and Log Cleanup
Eight commits focus on silent correctness risks and observability noise, with no new features. The highest-impact fixes close a logical replication skip during concurrent index changes and stale lock-wait timestamps.
Duration: PT2M15S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-09-28T13:07:33Z
- Audio duration: PT2M15S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Hello, today is September 28th, 2026.
The lead pattern today is prevention of silent failures — small races and counters that mislead monitoring or leave data changes skipped without an error.
First, replication and locking reliability. In commit ad36e36, the apply worker could silently skip an update as a missing-update conflict if an index was dropped or rebuilt between two checks for whether that index was the replica identity. The fix records that answer once in the relation map instead of rechecking…
Second, guardrails against stuck tables and noisy logs. Commit 5e59290 enforces the 32,767 limit on the check-constraint count stored in P G class. Beyond that, the counter could overflow and leave a table effectively undroppable. For operators, this turns a permanent catalog corruption into an early, clear error.…
Finally, low-risk code health. Two commits from Michael Paquier retire a custom O I D 8 formatting macro in favor of portable 64-bit printing to avoid breaking translated messages. Another refactor consolidates duplicate T O A S T pointer assembly into a single helper with no behavior change, while a new counted-by…
What's next: most of these are marked for backpatch to…
Nearby episodes from PostgreSQL
- Weekly Recap - Hardening Privileges and Edge-Case Reliability
- pg_dump Tar Restore Fix
- Privilege Fixes and Stats Restore Repairs
- Repack, Vacuum and Replication Hardening
- Snapshot and Visibility Map Correctness
- Concurrency Race Fixes and Replay Relief
- Upgrade Check and Error Code Cleanup
- Simplified Hashing for Sort Estimates