3 ms·
The dirty pages can be written out in physical address order no matter what indexing structure is used. What real databases do involves a bunch of complicated c
by jasonwatkinspdx 3y ago
The dirty pages can be written out in physical address order no matter what indexing structure is used. What real databases do involves a bunch of complicated choices, but basically there's ways you can make checkpoints incremental such that it's nearly always large sequential writes.
- eatonphil 3y agoSure it can be written in order but it still can involve non-consecutive writes which I assumed is closer to random writes from the disk's perspective.