Fuzzy checkpoints differ from naive checkpoints by

Question

Accepted Answer

A. transactions continue while dirty pages flush in background

A naive checkpoint freezes all transactions while every dirty page flushes.
That's too slow for production.
Fuzzy checkpoints let writers keep running and flush dirty pages in the background
the checkpoint record records which pages are still being written.
Recovery handles the in-flight state correctly.
Skipping the flush would break the checkpoint guarantee.

Answer

skipping the flush step entirely

Answer

writing only the commit log records, not the data pages

Answer

using a separate disk for the checkpoint marker

Fuzzy checkpoints differ from naive checkpoints by

Keep practising Database Management Systems