Checkpointing

Difficulty: Advanced

Question

What is the purpose of Checkpointing in a database?

Answer

To flush 'dirty' (modified) data from memory to disk, ensuring the data files are up-to-date and reducing the amount of WAL log that needs to be replayed during recovery.

Concepts covered

WAL, Recovery Time