Specifies how long the standby server should wait when WAL data is not available from any sources (streaming replication, local pg_wal or WAL archive) before trying again to retrieve WAL data. If this value is specified without units, it is taken as milliseconds. The default value is 5 seconds. This parameter can only be set in the postgresql.conf file or on the server command line.
This parameter is useful in configurations where a node in recovery needs to control the amount of time to wait for new WAL data to be available. For example, in archive recovery, it is possible to make the recovery more responsive in the detection of a new WAL log file by reducing the value of this parameter. On a system with low WAL activity, increasing it reduces the amount of requests necessary to access WAL archives, something useful for example in cloud environments where the amount of times an infrastructure is accessed is taken into account.
- Have SIGHUP instead of SIGTERM for config reload in logical replication launcher
- Re: Have SIGHUP instead of SIGTERM for config reload in logical replication launcher
- Re: Subscription test 013_partition.pl fails under CLOBBER_CACHE_ALWAYS
- Re: RecoveryWalAll and RecoveryWalStream wait events
- Re: Is Recovery actually paused?