PostgreSQL: Wrong-Result Fixes and Memory Hardening
Multiple patches fix silent wrong results in NOT IN queries, Memoize caching, and trigram indexes, alongside foreign-data-wrapper planning and memory-safety hardening. The pattern is reliability and correctness across supported versions.
Duration: PT2M16S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-11-04T14:03:28Z
- Audio duration: PT2M16S
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 Wednesday, November 4th, 2026, and this is your PostgreSQL briefing.
Today's signal is correctness over features: almost every change fixes a case where the database could return wrong answers, miss rows, or read freed memory.
First, three silent data errors. A fix in commit b 7 e e 0 9 tightens the NOT IN to anti-join conversion from version 19. If a subquery output was wrapped in a type coercion that can turn a non-null value into null, the anti-join could keep rows it should have filtered. The fix only allows the conversion for a…
Second, more efficient remote queries. Two related changes by David Rowley address the Postgres foreign data wrapper. When an ORDER BY is fully redundant, no sort is needed, so the ordered path can now be marked pushdown-safe and allow LIMIT to be pushed to the remote server. The back-branch companion relaxes an…
Third, memory safety and hardening. Commit a 6 2 5 e 1 5 enables the compiler option strict flex arrays level one, so most trailing arrays with a declared size are now bounds-checked, with targeted handling for JSON structures and full-text position vectors. Commit e 5 f 6 a 7 a fixes a use-after-free in…
What's next: if you…
Nearby episodes from PostgreSQL
- Weekly Recap - Reverts, Query Fixes, and Standby Safety
- JSON Revert and CI Overhaul
- Window Hangs, Planner Crashes and Replication Hardening
- Silent Correctness Fixes for Backups, Sorting and JSON
- Backup Safety, Planner Correctness, and Maintenance Tuning
- Stale Cache Fixes and Backup Data Loss
- Weekly Recap - Executor Correctness and Data Safety
- GSS Leak Fix and Concurrency Crash Fixes