In regards to 9.1.x, I would like to learn some details of the nature of “checkpointing”
=== Question 1 ===
- page 123 is dirty
- "checkpointing" starts
- page 123 gets written to disk, as part of this checkpoint
- page 123 gets modified again
? Does it get written to disk again, as part of this checkpoint?
- "checkpointing" finishes
=== Question 2 ===
- page 123 is dirty
- "checkpointing" starts
- page 123 gets modified again
- page 123 gets written to disk, as part of this checkpoint
? So does the most recent mod get written to disk, even if that mod is not committed yet ?
- "checkpointing" finishes
=== Question 3 ===
When does the full-page-writing to WAL happen ?
Is it after the start of the "checkpointing" or after the finish of the "checkpointing" ?
Thanks,
-dvs-