File tree Expand file tree Collapse file tree 1 file changed +4
-6
lines changed Expand file tree Collapse file tree 1 file changed +4
-6
lines changed Original file line number Diff line number Diff line change 424
424
linkend="guc-checkpoint-segments"> log segments, or every <xref
425
425
linkend="guc-checkpoint-timeout"> seconds, whichever comes first.
426
426
The default settings are 3 segments and 300 seconds (5 minutes), respectively.
427
- In cases where little or no WAL has been written, checkpoints will be
428
- skipped even if checkpoint_timeout has passed. At least one new WAL segment
429
- must have been created before an automatic checkpoint occurs. The time
430
- between checkpoints and when new WAL segments are created are not related
431
- in any other way. If file-based WAL shipping is being used and you want to
432
- bound how often files are sent to standby server to reduce potential data
427
+ In cases where no WAL has been written since the previous checkpoint, new
428
+ checkpoints will be skipped even if checkpoint_timeout has passed.
429
+ If WAL archiving is being used and you want to put a lower limit on
430
+ how often files are archived in order to bound potential data
433
431
loss, you should adjust archive_timeout parameter rather than the checkpoint
434
432
parameters. It is also possible to force a checkpoint by using the SQL
435
433
command <command>CHECKPOINT</command>.
You can’t perform that action at this time.
0 commit comments