deadlock_timeout

A configuration parameter determining the amount of time to wait on a lock before checking to see if there is a deadlock condition.

deadlock_timeout is a configuration parameter determining the amount of time to wait on a lock before checking to see if there is a deadlock condition.

deadlock_timeout was added in PostgreSQL 6.4.

Default value

The default value for deadlock_timeout is: 1s.

Usage

If log_lock_waits is set to on, deadlock_timeout also determines the interval before the lock wait is logged.

Change history

Categories

GUC configuration item, Locking

See also

log_lock_waits, deadlock_timeout, statement timeout