PostgreSQL: Silent Wrong-Result Fixes and Worker Reliability
Today's activity centers on query correctness, with fixes for stale plans, Memoize caching, and MERGE on partitioned tables that could return wrong data, plus reliability improvements for background workers.
Duration: PT2M42S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-11-11T14:03:54Z
- Audio duration: PT2M42S
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 11th, 2026, and this is your PostgreSQL developer briefing.
The signal today is correctness over features — most changes fix cases where Postgres could silently return wrong data or miss rows.
Start with the query executor. Commit 9b80b31 fixes stale initialization plans after the planner removes a trivial subquery scan or single-child append. The removed node's parameter dependencies weren't merged into its child, so on rescan, lateral queries over a single partition could reuse stale values. Related,…
A second theme is background process reliability. Commit 5bf9197 changes how interruptible background workers are stopped for database-level commands, signaling them directly instead of marking slots terminated, so they can restart according to their restart time setting — important for extensions that connect based…
Finally, type handling and index safety. Commit c5daeb1 fixes SQL JSON passing for character, name, and domain-over-text values like current user, which previously failed at runtime — now handled in the executor so existing views benefit. Commit 1d657c6 fixes uninitialized memory in text-search GiST page splits that…
Also, a Perl interface fix…
Nearby episodes from PostgreSQL
- Vacuum Estimates and Semaphore Cleanup
- Silent Correctness and Upgrade Reliability Fixes
- Stats, Planner and Replication Crash Fixes
- 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