diff options
author | Robert Haas <rhaas@postgresql.org> | 2012-08-30 15:06:55 -0400 |
---|---|---|
committer | Robert Haas <rhaas@postgresql.org> | 2012-08-30 15:08:53 -0400 |
commit | d561fc5396e537452065c3531cb43edf11a8dbf0 (patch) | |
tree | 8c77a92e6be553449396360c795e1b2394be472b | |
parent | 36bffe4ffa5a7492d78a889e7feb0838be5449f1 (diff) | |
download | postgresql-d561fc5396e537452065c3531cb43edf11a8dbf0.tar.gz postgresql-d561fc5396e537452065c3531cb43edf11a8dbf0.zip |
Fix checkpoint_timeout documentation to reflect current behavior.
Jeff Janes
-rw-r--r-- | doc/src/sgml/wal.sgml | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/doc/src/sgml/wal.sgml b/doc/src/sgml/wal.sgml index e34faffce2a..b21afce4b79 100644 --- a/doc/src/sgml/wal.sgml +++ b/doc/src/sgml/wal.sgml @@ -424,12 +424,10 @@ linkend="guc-checkpoint-segments"> log segments, or every <xref linkend="guc-checkpoint-timeout"> seconds, whichever comes first. The default settings are 3 segments and 300 seconds (5 minutes), respectively. - In cases where little or no WAL has been written, checkpoints will be - skipped even if checkpoint_timeout has passed. At least one new WAL segment - must have been created before an automatic checkpoint occurs. The time - between checkpoints and when new WAL segments are created are not related - in any other way. If file-based WAL shipping is being used and you want to - bound how often files are sent to standby server to reduce potential data + In cases where no WAL has been written since the previous checkpoint, new + checkpoints will be skipped even if checkpoint_timeout has passed. + If WAL archiving is being used and you want to put a lower limit on + how often files are archived in order to bound potential data loss, you should adjust archive_timeout parameter rather than the checkpoint parameters. It is also possible to force a checkpoint by using the SQL command <command>CHECKPOINT</command>. |