Re: heavily contended lwlocks with long wait queues scale badly

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: heavily contended lwlocks with long wait queues scale badly
Дата
Msg-id ZZ9kSJP7fX4RP173@paquier.xyz
обсуждение исходный текст
Ответ на Re: heavily contended lwlocks with long wait queues scale badly  (Nathan Bossart <nathandbossart@gmail.com>)
Ответы Re: heavily contended lwlocks with long wait queues scale badly  ("Jonathan S. Katz" <jkatz@postgresql.org>)
Список pgsql-hackers
On Wed, Jan 10, 2024 at 09:17:47PM -0600, Nathan Bossart wrote:
> Now that commit a4adc31 has had some time to bake and concerns about
> unintended consequences may have abated, I wanted to revive this
> back-patching discussion.  I see a few possibly-related reports [0] [1]
> [2], and I'm now seeing this in the field, too.  While it is debatable
> whether this is a bug, it's a quite nasty issue for users, and it's both
> difficult to detect and difficult to work around.

+1, I've seen this becoming a PITA for a few things.  Knowing that the
size of PGPROC does not change at all, I would be in favor for a
backpatch, especially since it's been in the tree for more than 1
year, and even more knowing that we have 16 released with this stuff
in.
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows
Следующее
От: "Dian Fay"
Дата:
Сообщение: Re: add function argument names to regex* functions.