aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2012-08-30 15:06:55 -0400
committerRobert Haas <rhaas@postgresql.org>2012-08-30 15:08:36 -0400
commit9bedfbd02b48096f435c5b111591d4e5b717e547 (patch)
tree865e60136c86f254d1b1f7f12056ed2af24c9626 /doc/src
parent83fbfec383d7f7ef1331ba02db3d0fdf50abf112 (diff)
downloadpostgresql-9bedfbd02b48096f435c5b111591d4e5b717e547.tar.gz
postgresql-9bedfbd02b48096f435c5b111591d4e5b717e547.zip
Fix checkpoint_timeout documentation to reflect current behavior.
Jeff Janes
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/wal.sgml10
1 files changed, 4 insertions, 6 deletions
diff --git a/doc/src/sgml/wal.sgml b/doc/src/sgml/wal.sgml
index c66ae291e00..f0c2260ed9e 100644
--- a/doc/src/sgml/wal.sgml
+++ b/doc/src/sgml/wal.sgml
@@ -422,12 +422,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>.