Re: Set log_lock_waits=on by default - Mailing list pgsql-hackers

From Shinya Kato
Subject Re: Set log_lock_waits=on by default
Date
Msg-id CAOzEurS0jbDrjmVFgE4QQ_O0bnDtJMaaFsy3=pX0RLYXBcjVpg@mail.gmail.com
Whole thread Raw
In response to Re: Set log_lock_waits=on by default  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
Hi,

On Tue, Apr 8, 2025 at 11:33 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> Well, it didn't make v18.
>
> But this patch got enough votes in favor that I am not going to withdraw it.

Thank you for discussing it.

diff --git a/src/backend/utils/misc/guc_tables.c
b/src/backend/utils/misc/guc_tables.c
index f7c9882f7c..1f3d56e6ee 100644
--- a/src/backend/utils/misc/guc_tables.c
+++ b/src/backend/utils/misc/guc_tables.c
@@ -1519,7 +1519,7 @@ struct config_bool ConfigureNamesBool[] =
  NULL
  },
  &log_lock_waits,
- false,
+ true,
  NULL, NULL, NULL
  },
  {

Due to 635998965 [0], you need to change guc_parameters.dat instead of
guc_tables.c.

[0] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=63599896545c7869f7dd28cd593e8b548983d613


--
Best regards,
Shinya Kato
NTT OSS Center



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible
Next
From: kasaharatt
Date:
Subject: Re: Add log_autovacuum_{vacuum|analyze}_min_duration