PostgreSQL: Query Tracking Overhaul and Data Integrity Fixes
Activity centers on correctness in edge cases rather than new features, led by a new QueryDesc extension state that fixes pg_stat_statements toplevel tracking, alongside hardening for partitioned constraints, base backups, and SSL.
Duration: PT2M10S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-10-27T13:04:48Z
- Audio duration: PT2M10S
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 Tuesday, October 27th, 2026.
The big thread today is correctness in edge cases — how queries are tracked, how constraints propagate, and how backups and secure connections survive failures.
First, extension state handling. Two linked commits rebuild how monitoring extensions follow a query across executor stages. A new facility lets extensions attach private state to the query descriptor, replacing backend-wide variables that break when end runs in a different context than start. The follow-up uses it…
Second, data integrity and availability. A fix for bug 19770 blocks not-null no-inherit constraints on partitioned tables, closing a create-table-like loophole that let partitions miss the constraint and hold nulls. The commit includes a query against the system catalogs to find affected databases. Separately, base…
Finally, language and minor reliability fixes. P L p g S Q L now maps any-compatible multi-range to a concrete multi-range type, fixing function creation and a stale cache reuse that broke integer-range calls. Event trigger functions initialize found to false as documented.
What's next: extension authors can adopt the new query descriptor state, and…
Nearby episodes from PostgreSQL
- GSS Leak Fix and Concurrency Crash Fixes
- Planner Correctness and Crash Fixes
- Planner Correctness and JSON Error Handling
- TOAST, Backup and Hash Table Reliability Fixes
- Planner Correctness and Crash Safety Fixes
- Weekly Recap - Planner Correctness and Data Safety Fixes
- Index Correctness Fixes and CI Move to Meson
- Hash Join Performance Fix