PostgreSQL: Tightening Up Before Release
Ahead of the PostgreSQL 19 release, today's commits focus on closing edge-case bugs in transaction handling, the REPACK background worker, and the new pg_plan_advice feature, plus a defensive fix to statistics tracking.
Duration: PT2M34S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-09-17T13:05:27Z
- Audio duration: PT2M34S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
You're listening to the PostgreSQL briefing for September 17th, 2026.
The clear pattern today: this is release-hardening work. Several commits address edge cases that only show up under failure conditions or unusual timing, all backpatched through version 19, which points to last-mile stabilization before that release ships.
Start with transaction handling. Fujii Masao's fix, commit 999ce9b, resolves an assertion failure that could crash a backend when an internal subtransaction aborts during commit or prepare transaction, for example when a deferred trigger fires and a PL/pgSQL exception block catches the error. This one is backpatched…
Second theme: the REPACK background worker is getting real reliability work. Álvaro Herrera landed two fixes: commit a62ff08 makes the worker honor timeout settings from the calling session instead of database-level defaults, which could otherwise cancel the wait unexpectedly. Commit 16735af fixes startup and…
Third theme: pg_plan_advice is getting stricter, not looser. Robert Haas's commits 63920eb and 5e595d6 both disallow ambiguous or malformed advice syntax, specifically partition names without a schema, and empty sublists in join order. Both…
Two…
Nearby episodes from PostgreSQL
- Table Access and REPACK Reliability
- Correctness Fixes Across Storage and Concurrency
- Version 19 Cleanup and Correctness Fixes
- Weekly Recap - Correctness Fixes and Replication Safety
- Hardening the Wait For LSN Feature
- Repack Decoding Bugs and a Schema Feature Retreat
- Correctness Fixes Around Concurrency and Replication
- Correctness Fixes in the Query Planner and Foreign Keys