diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2025-09-12 07:57:06 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2025-09-12 07:57:06 +0200 |
| commit | 2aac62be8cbb870ccf8c5b3fbb8a4e4aa8a14a73 (patch) | |
| tree | fa1efdee23b1b6692b2d375655d0a957276596aa /doc/src | |
| parent | 25f36066dd2abde74faa12f08e5e498a95128cd0 (diff) | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 2a3685f474a..3c33d5d0fbc 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -7929,7 +7929,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a ' Controls whether a log message is produced when a session waits longer than <xref linkend="guc-deadlock-timeout"/> to acquire a lock. This is useful in determining if lock waits are causing - poor performance. The default is <literal>off</literal>. + poor performance. The default is <literal>on</literal>. Only superusers and users with the appropriate <literal>SET</literal> privilege can change this setting. </para> |