PostgreSQL: Table Access and REPACK Reliability
The biggest change today is a major architectural rework of how table access methods handle index scans, while a cluster of REPACK and CLUSTER fixes address correctness and progress-reporting gaps across supported versions.
Duration: PT2M19S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-09-16T13:05:44Z
- Audio duration: PT2M19S
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 September 16th, 2026, and here's what moved in the Postgres codebase.
The headline commit is Peter Geoghegan's new slot-based table access method interface for index scans, in ddce1da. This introduces a single entry point, table index get next slot, that both plain and index-only scans dispatch through. The practical payoff: heapam can now specialize code paths for each scan type,…
Second theme: REPACK correctness and observability got real attention. Álvaro Herrera's commit 7814282 fixes a gap where REPACK could attempt to rebuild indexes that failed validation partway through, rather than just those not yet ready — it now correctly errors on any invalid index. Meanwhile two commits from…
A few smaller but notable fixes: Heikki Linnakangas closed a multixact truncation bug at page boundaries that could produce bogus wraparound warnings, and Alexander Korotkov fixed a semijoin collation bug where non-deterministic collations could cause incorrect row counts in subqueries. Masahiko Sawada also sped up…
What's next: watch for the promised follow-on commit adding batched index scans on top of the new table access method interface — it's expected to enable table block…
T…
Nearby episodes from PostgreSQL
- 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
- Repack Command Gets Locked Down