Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Explain why a database keeps its own cache of disk pages in memory.
- Explain what a dirty page is, and why it cannot simply be discarded.
- Describe, at a high level, how a buffer pool decides which page to evict.
- Connect the buffer pool to why a repeated query can be far faster the second time.
Every block read in this level ultimately goes through memory first. This page covers that memory layer directly: why it exists, and the one rule that makes it more than a simple cache.