Re: walsender performance regression due to logical decoding on standby changes

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: walsender performance regression due to logical decoding on standby changes
Дата
Msg-id 1a65cb21027ce15a3b2f3c0628f7c55f8a2f0d19.camel@j-davis.com
обсуждение исходный текст
Ответ на walsender performance regression due to logical decoding on standby changes  (Andres Freund <andres@anarazel.de>)
Ответы Re: walsender performance regression due to logical decoding on standby changes  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Tue, 2023-05-09 at 12:02 -0700, Andres Freund wrote:
> I don't think the approach of not having any sort of "registry" of
> whether
> anybody is waiting for the replay position to be updated is
> feasible. Iterating over all walsenders slots is just too expensive -

Would it work to use a shared counter for the waiters (or, two
counters, one for physical and one for logical), and just early exit if
the count is zero?

Regards,
    Jeff Davis




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

Предыдущее
От: Andres Freund
Дата:
Сообщение: walsender performance regression due to logical decoding on standby changes
Следующее
От: Corey Huinker
Дата:
Сообщение: Re: Large files for relations