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

From Michael Banck
Subject Re: Set log_lock_waits=on by default
Date
Msg-id 659ffa38.170a0220.eea6a.28fc@mx.google.com
Whole thread Raw
In response to Set log_lock_waits=on by default  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Set log_lock_waits=on by default
List pgsql-hackers
Hi,

On Thu, Dec 21, 2023 at 02:29:05PM +0100, Laurenz Albe wrote:
> Here is a patch to implement this.
> Being stuck behind a lock for more than a second is almost
> always a problem, so it is reasonable to turn this on by default.

I also think that this should be set to on.

I had a look at the patch and it works fine. Regarding the
documentation, maybe the back-reference at deadlock_timeout could be
made a bit more explicit then as well, as in the attached patch, but
this is mostly bikeshedding.


Michael

Attachment

pgsql-hackers by date:

Previous
From: vignesh C
Date:
Subject: Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt"
Next
From: vignesh C
Date:
Subject: Re: Assertion failure in SnapBuildInitialSnapshot()