Buffer Management and Disk I/O

📘 DBMS 👁 108 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

🤖 AI Quizer Assistant

📝 Quiz
📚 Categories
🏆 Leaderboard
📊 My Score
❓ Help
👋 Hi! I'm your AI quiz assistant for Quizer.in!

I can help you with:
• 📝 Finding quizzes
• 🏆 Checking leaderboard
• 📊 Your performance stats

Type 'help' to get started! 🚀
AI is thinking...