Type: | bool |
Default: | on |
Context: | sighup |
Restart: | false |
Causes checkpoints and restartpoints to be logged in the server log. Some statistics are included in the log messages, including the number of buffers written and the time spent writing them. This parameter can only be set in the postgresql.conf file or on the server command line. The default is on.
Recommendations
When doing performance analysis, it's often a good idea to turn on most of the logging options and log them to a CSVlog.
On StackOverflow
On pgsql-hackers
- Re: Generalize ereport_startup_progress infrastructure
- Re: Add checkpoint and redo LSN to LogCheckpointEnd log message
- Re: O(n) tasks cause lengthy startups and checkpoints
- Re: Race between KeepFileRestoredFromArchive() and restartpoint
- Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations