Thread: Re: Redux: Throttle WAL inserts before commit

Re: Redux: Throttle WAL inserts before commit

From
Jakub Wartak
Date:
On Tue, Aug 27, 2024 at 12:51 PM Shirisha Shirisha
<shirisha.sn@broadcom.com> wrote:
>
> Hello hackers,
>
> This is an attempt to resurrect the thread [1] to throttle WAL inserts
> before the point of commit.
>
> Background:
>
> Transactions on commit, wait for replication and make sure WAL is
> flushed up to commit lsn on standby, when synchronous_commit is on.

Hi Shirisha,

Just to let you know, there was a more recent attempt at that in [1]
in Jan 2023 , also with a resurrection attempt there in Nov 2023 by
Tomas. Those patches there seemed to have received plenty of attention
back then and were also based on SyncRepWaitForLSN(), but somehow
maybe we ran out of steam and there was not that big interest back
then.

Maybe you could post a review there (for Tomas's more modern recent
patch), if it is helping your use case even today. That way it could
get some traction again?

-Jakub Wartak.