max_standby_streaming_delay

A GUC determining how long a standby server should wait before canceling queries that conflict with WAL

max_standby_streaming_delay is a GUC determining how long a standby server should wait before canceling queries that conflict with pending WAL entries received via streaming replication.

max_standby_streaming_delay was added in PostgreSQL 9.0.

Usage

max_standby_streaming_delay requires hot_standby to be set to on. It has no effect when run on a server which is not in recovery.

Default

Default value for max_standby_streaming_delay is: 30s.

Change history

Note that max_standby_streaming_delay and max_standby_archive_delay were added in place of max_standby_delay, which was introduced earlier in the PostgreSQL 9.0 release cycle (commit efc16ea5).

Categories

Replication, WAL

See also

max_standby_archive_delay, pg_stat_database_conflicts