| Type: | integer |
| Default: | 300 (5min) |
| Min: | 30 (30s) |
| Max: | 86400 (1d) |
| Unit: | seconds (s) |
| Context: | sighup |
| Restart: | false |
Maximum time between automatic WAL checkpoints. If this value is specified without units, it is taken as 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.
On StackOverflow
On pgsql-hackers
- Re: May be BUG. Periodic burst growth of the checkpoint_req counter on replica.
- Re: filesystem full during vacuum - space recovery issues
- Re: Sample rate added to pg_stat_statements
- Re: Introduce XID age and inactive timeout based replication slot invalidation
- Re: [RFC] Lock-free XLog Reservation from WAL