Re: [GENERAL] checkpoint clarifications needed - Mailing list pgsql-general

From Tom DalPozzo
Subject Re: [GENERAL] checkpoint clarifications needed
Date
Msg-id CAK77FCSdy-yURzPxj+Bf1HU7DTB4XqCbWZnF-P1KL=2AfBMUPQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] checkpoint clarifications needed  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: [GENERAL] checkpoint clarifications needed
Re: [GENERAL] checkpoint clarifications needed
List pgsql-general
https://www.postgresql.org/docs/9.5/static/wal-internals.html

"After a checkpoint has been made and the log flushed, the checkpoint's position is saved in the file pg_control. Therefore, at the start of recovery, the server first reads pg_control and then the checkpoint record; then it performs the REDO operation by scanning forward from the log position indicated in the checkpoint record. Because the entire content of data pages is saved in the log on the first page modification after a checkpoint (assuming full_page_writes is not disabled), all pages changed since the checkpoint will be restored to a consistent state."


Hi, yes I know that, it's what I meant in my point 3). As it says first  "the checkpoint's position (NOT the record)is saved in the file pg_control" then I had some doubt.
Regards
Pupillo

 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] checkpoint clarifications needed
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] checkpoint clarifications needed