deadlock_timeout
A configuration parameter determining how long to wait before checking for 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
- PostgreSQL 7.4
- changed from
PGC_POSTMASTER
toPGC_SIGHUP
(commit 77ede890)
- changed from
- PostgreSQL 7.1
- PostgreSQL 6.4
- added (initial commit 7414d619)
References
- PostgreSQL documentation: deadlock_timeout
Useful links
- Deadlocks in PostgreSQL - November 2017 blog article by Igor Šarčević