Re: Set log_lock_waits=on by default

From: Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Set log_lock_waits=on by default
Date: 2023-12-21 15:21:26
Message-ID: 4bc263f0-0542-445d-bb3a-7c1f1b6ac228@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Le 21/12/2023 à 14:29, Laurenz Albe a écrit :
> 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 think it's a really good idea. At Dalibo, we advise our customers to
switch it on. AFAICT, it's never been a problem.

Best regards,
Frédéric

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2023-12-21 15:22:49 Re: ci: Build standalone INSTALL file
Previous Message Tomas Vondra 2023-12-21 15:20:45 Re: index prefetching