Buffer Management and Disk I/O

📘 DBMS 👁 79 views 📅 Nov 14, 2025
⏱ Estimated reading time: 1 min

Buffer Management and Disk I/O

Buffer management is the subsystem that caches disk pages in memory so that the database can reduce disk I/O.

Buffer Pool

The buffer pool holds recently used pages. Effective sizing reduces costly disk reads.

Replacement Policies

  • LRU: Least Recently Used
  • MRU: Most Recently Used
  • Clock: An efficient approximation of LRU

I/O Optimization

  • Group writes to reduce random I/O (write-ahead logging helps).
  • Pin frequently used pages in memory.
  • Tune page size and buffer pool size according to workload.

🔒 Some advanced sections are available for Registered Members
Register Now

Share this Post


← Back to Tutorials

Popular Competitive Exam Quizzes