Re: Set log_lock_waits=on by default

Поиск
Список
Период
Сортировка
От Michael Banck
Тема Re: Set log_lock_waits=on by default
Дата
Msg-id 659ffa38.170a0220.eea6a.28fc@mx.google.com
обсуждение исходный текст
Ответ на Set log_lock_waits=on by default  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Set log_lock_waits=on by default  (Michael Banck <mbanck@gmx.net>)
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: vignesh C
Дата:
Сообщение: Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt"
Следующее
От: vignesh C
Дата:
Сообщение: Re: Assertion failure in SnapBuildInitialSnapshot()