PostgreSQL: Stats, Planner and Replication Crash Fixes
Today's activity centers on correctness fixes for empty statistics arrays, outer-join planning, and logical replication. The highest-impact changes prevent stats loss on restore, wrong planner results, and a replication crash loop on detach-pending partitions.
Duration: PT2M23S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-11-12T14:03:59Z
- Audio duration: PT2M23S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Good morning, it's November 12th, 2026.
The dominant signal today is correctness under edge cases — empty statistics, outer joins, and partition states that previously caused crashes or wrong results.
First, statistics handling. Two linked fixes address empty value arrays introduced by an earlier change to how analyze stores statistics. One update, in commit 44cf289, refactors expression statistics serialization to share code with table statistics, fixing unexpected null value errors reported as bug 19849. The…
Second, the query planner tightens outer join logic in three places. Commit f14a16c rejects join paths parameterized by a pushed-down outer join completed at the current join, closing a gap that could trigger an assertion. Commit e50d958 fixes constant propagation through full joins, where reversed or same-side…
Finally, reliability for replication: commit 9a84976 fixes a crash decoding changes to a partition left in detach-pending state after a concurrent detach is interrupted. The decoder assumed ancestors always exist, leading to assertion failures and crash loops for for-all-tables publications. The fix treats such…
Also noted: a parallel vacuum tuple-count type correction…
Nearby episodes from PostgreSQL
- Vacuum Estimates and Semaphore Cleanup
- Silent Correctness and Upgrade Reliability Fixes
- Silent Wrong-Result Fixes and Worker Reliability
- Composite Type Security Hardening
- Standby Inspection Guards and psql Interrupt Fix
- Weekly Recap - Reverts, Query Fixes, and Standby Safety
- JSON Revert and CI Overhaul
- Window Hangs, Planner Crashes and Replication Hardening