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
- Vacuum Visibility and Reliability Fixes
- Time Zone Update and Build Reliability Fixes
- Row Security and Replication Safeguards
- Repack Data Loss Fix and Test Stability
- Weekly Recap - Hardening Privileges and Edge-Case Reliability
- pg_dump Tar Restore Fix
- Privilege Fixes and Stats Restore Repairs
- Repack, Vacuum and Replication Hardening