diff options
author | Simon Riggs <simon@2ndQuadrant.com> | 2011-11-02 15:26:33 +0000 |
---|---|---|
committer | Simon Riggs <simon@2ndQuadrant.com> | 2011-11-02 15:26:33 +0000 |
commit | 18fb9d8d21a28caddb72c7ffbdd7b96d52ff9724 (patch) | |
tree | 7f7cb78f703f06451eab45e30dbecc39d4b0c314 /src/backend/executor/functions.c | |
parent | 9aceb6ab3c202a5bf00d5f00436bb6ad285fc0bf (diff) | |
download | postgresql-18fb9d8d21a28caddb72c7ffbdd7b96d52ff9724.tar.gz postgresql-18fb9d8d21a28caddb72c7ffbdd7b96d52ff9724.zip |
Reduce checkpoints and WAL traffic on low activity database server
Previously, we skipped a checkpoint if no WAL had been written since
last checkpoint, though this does not appear in user documentation.
As of now, we skip a checkpoint until we have written at least one
enough WAL to switch the next WAL file. This greatly reduces the
level of activity and number of WAL messages generated by a very
low activity server. This is safe because the purpose of a checkpoint
is to act as a starting place for a recovery, in case of crash.
This patch maintains minimal WAL volume for replay in case of crash,
thus maintaining very low crash recovery time.
Diffstat (limited to 'src/backend/executor/functions.c')
0 files changed, 0 insertions, 0 deletions