Default to log_lock_waits=on
authorPeter Eisentraut <peter@eisentraut.org>
Fri, 12 Sep 2025 05:57:06 +0000 (07:57 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Fri, 12 Sep 2025 05:57:06 +0000 (07:57 +0200)
commit2aac62be8cbb870ccf8c5b3fbb8a4e4aa8a14a73
treefa1efdee23b1b6692b2d375655d0a957276596aa
parent25f36066dd2abde74faa12f08e5e498a95128cd0
Default to log_lock_waits=on

If someone is stuck behind a lock for more than a second, that is
almost always a problem that is worth a log entry.

Author: Laurenz Albe <laurenz.albe@cybertec.at>
Reviewed-By: Michael Banck <mbanck@gmx.net>
Reviewed-By: Robert Haas <robertmhaas@gmail.com>
Reviewed-By: Christoph Berg <myon@debian.org>
Reviewed-By: Stephen Frost <sfrost@snowman.net>
Discussion: https://postgr.es/m/b8b8502915e50f44deb111bc0b43a99e2733e117.camel%40cybertec.at
doc/src/sgml/config.sgml
src/backend/storage/lmgr/proc.c
src/backend/utils/misc/guc_parameters.dat
src/backend/utils/misc/postgresql.conf.sample