What is a database checkpoint?

A checkpoint writes in-memory changes to disk to reduce recovery time.

Checkpoints are mechanisms where dirty pages from memory are flushed to disk to reduce the amount of redo log needed during crash recovery. They ensure that the database can recover faster by limiting how far back the WAL (Write-Ahead Log) must be replayed.