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- |
