Search Postgresql Archives

Re: checkpoint clarifications needed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Reread your original post and realized you where also asking about transaction consistency and WALs. The thumbnail version is that Postgres writes transactions to the WALs before they are written to the data files on disk. A checkpoint represents a point in the sequence when is is known that the changes recorded in the WAL have been also recorded in the disk data files. So Postgres then knows that in a recovery scenario it needs to only redo/replay the WAL changes that are past the last checkpoint. So the transactions are there it is just a matter of if they need to be replayed or not. This is subject to caveats:

https://www.postgresql.org/docs/9.5/static/wal-reliability.html


Hi, I had already read that doc but I can't  answer clearly to my questions 2,4 and 5.
Regards
Pupillo



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux