Parameter type: Integer
Default value: 5min
Range: 30s to 3600s
Minimum scope of effect: Cluster
When value changes take effect: Reload
Required authorization to activate: EPAS service account
Maximum time between automatic WAL checkpoints, in seconds. Increasing this parameter can increase the amount of time needed for crash recovery.
checkpoint_timeout to a larger value, such as 15 minutes, can reduce the I/O load on your system, especially when using large values for
The downside of making these adjustments to the checkpoint parameters is that your system uses a modest amount of additional disk space and takes longer to recover in the event of a crash. However, for most users, this is worth it for a significant performance improvement.