Tag
transaction-ids
- 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
- Sep 8, 2025 When a Snapshot Is Taken and How Commit Order Is Assigned The choice between transaction-start and first-statement snapshots, the in-progress list that defines the read view, and why a single commit counter is a shared resource. databases
- Jul 19, 2025 Heap Tuple Headers, Transaction Identifiers, and Visibility Rules How a row version records the transaction that created it and the one that deleted it, and how a reader decides whether that version belongs in its snapshot. 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