Tag
buffer-pool
- Aug 13, 2026 Buffer Pool Frames, Pin Counts, and Replacement Under Pin Pressure How a page identifier is mapped to a frame of memory, why a pin is not a lock, what happens when every candidate for eviction is pinned, and how clock sweeps approximate LRU. databases
- May 10, 2026 Page Compression: Prefix, Dictionary, and the Cost of Decoding How prefix truncation, shared dictionaries, and byte-level encoding shrink a page, why decompression sits on the critical path, and where compression defeats the buffer pool. databases
- Jun 2, 2025 Latch Coupling and Deadlock Avoidance in the Buffer Pool Why latches are not locks, how lock coupling keeps a B-tree descent deadlock-free, what a partitioned buffer pool hash table buys, and where contention concentrates. databases