Toggle navigation
Type: integer
Default: 300
Min: 30
Max: 86400
Unit: seconds (s)
Context: sighup
Restart: false

Maximum time between automatic WAL checkpoints, in seconds. The valid range is between 30 seconds and one day. The default is five minutes (5min). Increasing this parameter can increase the amount of time needed for crash recovery. This parameter can only be set in the postgresql.conf file or on the server command line.

Recommendations

If you do really large ETL batches, you may want to increase this setting to the maximum length of a batch run.

Comments