Skip to content
lectern.tv

Buffer Pool Managers, LRU-K Eviction & Direct I/O

Associate Professor of Databaseology

1:22:44·2023·undergraduate level
Path step 7: Connects durability guarantees to buffer pools, eviction policies, and direct I/O.

Explains why databases bypass OS page caches via O_DIRECT, manage page pin counts and latches, and prevent sequential-scan pollution using LRU-K and Clock policies.

Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)

Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/06-bufferpool.pdf

Notes: https://15445.courses.cs.cmu.edu/fall2023/notes/06-bufferpool.pdf

Comments

Add a comment...Sign in