Tag
vacuum
- Mar 10, 2026 The Transaction ID Horizon and What Happens at Wraparound How 32-bit transaction identifiers are consumed, why freezing exists, and the sequence of failures that turns a neglected counter into a refused-write outage. databases
- Dec 3, 2024 Vacuum Horizons, Dead Version Collection, and Table Bloat How an engine decides that a row version can never be seen again, why one old snapshot stalls collection for an entire database, and what freezing does to the identifier space. databases
- Dec 10, 2023 Dead Tuples, Bloat, and What VACUUM Actually Reclaims How update-in-place storage produces dead row versions, what a vacuum pass removes from pages, and why the table file does not shrink when it finishes. databases