PostgreSQL: Window Hangs, Planner Crashes and Replication Hardening
Today's activity centers on silent correctness bugs — hangs, crashes and wrong results from edge-case SQL in window functions, aggregates, JSON Table and the planner. Operational fixes add early validation for logical replication and let upgrades skip invalid databases.
Duration: PT2M29S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-11-06T14:03:26Z
- Audio duration: PT2M29S
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 for November 6th, 2026.
Today's PostgreSQL activity centers on one pattern: quiet correctness bugs that crash, hang, or return the wrong answer on edge-case SQL.
First, window functions with ignore nulls got two separate fixes. One commit, 69b20fd, fixes an infinite loop in first value and nth value when scanning frames ending at unbounded following with certain exclude clauses and no ordering — the loop never detected end of partition and advanced forever. The fix checks…
Second, three executor and planner fixes cover similar hidden traps. Commit edbe7ff fixes a crash with single-input aggregates that have multiple sort keys or distinct columns, where the executor chose the wrong fast sort path and missed needed temporary storage. Commit e405a46 fixes JSON table to assign collations…
Finally, operational hardening. Commit 161d5ff adds immediate validation for the output plugin libraries setting, so a bad value in config or connection options is rejected at once instead of failing later during logical replication. Commit 37a7664 teaches P G upgrade to skip invalid databases left behind by…
What's next: test ignore-nulls window queries, multi-key aggregates, and…
Nearby episodes from PostgreSQL
- Composite Type Security Hardening
- Standby Inspection Guards and psql Interrupt Fix
- Weekly Recap - Reverts, Query Fixes, and Standby Safety
- JSON Revert and CI Overhaul
- Silent Correctness Fixes for Backups, Sorting and JSON
- Wrong-Result Fixes and Memory Hardening
- Backup Safety, Planner Correctness, and Maintenance Tuning
- Stale Cache Fixes and Backup Data Loss