File tree 1 file changed +3
-3
lines changed
1 file changed +3
-3
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 there are little or no writes to the WAL , checkpoints will be
427
+ In cases where little or no WAL has been written , checkpoints will be
428
428
skipped even if checkpoint_timeout has passed. At least one new WAL segment
429
429
must have been created before an automatic checkpoint occurs. The time
430
430
between checkpoints and when new WAL segments are created are not related
431
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
433
- loss you should adjust archive_timeout parameter rather than the checkpoint
432
+ bound how often files are sent to standby server to reduce potential data
433
+ loss, you should adjust archive_timeout parameter rather than the checkpoint
434
434
parameters. It is also possible to force a checkpoint by using the SQL
435
435
command <command>CHECKPOINT</command>.
436
436
</para>
You can’t perform that action at this time.
0 commit comments