Multiple Buffer Pools

The DBMS does not always have a single buffer pool for the entire system

• Multiple buffer pool instances

• Per-database buffer pool

• Per-page type buffer pool

Helps reduce latch contention and improve locality

Approach #1: Object Id

-> Embed an object identifier in record ids and then maintain a mapping from objects to specific buffer pools

Approach #2: Hashing

-> Hash the page id to select which buffer pool to access.