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
- PostgreSQL 7.4
- changed from
PGC_POSTMASTERtoPGC_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ć