buffer pool
Memory a database uses to keep recently read disk pages, so it does not reread them from disk.
In more detail
It is the innermost cache and is always there, even when nobody thinks of it as a cache. In PostgreSQL it is sized by the shared_buffers setting.
Related terms
- cache — A store of earlier answers kept close to where they are needed so they can be reused instead of fetched or computed again.
- working set — The portion of data a system actively uses over a period, which ideally fits in memory.
- storage engine — The part of a database that actually stores records on disk and reads them back.
Taught in
- Caching Strategies And Topology — Scalable System Design & Distributed Architecture