Problems

LRU & Clock replacement policies are susceptible to sequential flooding.

  • A query performs a sequential scan that reads every page.

  • This pollutes the buffer pool with pages that are read once and then never again

The most recently used page is actually the most unneeded page.

Last updated