Re: walsender performance regression due to logical decoding on standby changes - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: walsender performance regression due to logical decoding on standby changes
Date
Msg-id 1a65cb21027ce15a3b2f3c0628f7c55f8a2f0d19.camel@j-davis.com
Whole thread Raw
In response to walsender performance regression due to logical decoding on standby changes  (Andres Freund <andres@anarazel.de>)
Responses Re: walsender performance regression due to logical decoding on standby changes
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: walsender performance regression due to logical decoding on standby changes
Next
From: Corey Huinker
Date:
Subject: Re: Large files for relations