Re: Time delayed LR (WAS Re: logical replication restrictions) - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Time delayed LR (WAS Re: logical replication restrictions)
Date
Msg-id 20230211020942.jr7wlz463mm6bm27@awork3.anarazel.de
Whole thread Raw
In response to RE: Time delayed LR (WAS Re: logical replication restrictions)  ("Takamichi Osumi (Fujitsu)" <osumi.takamichi@fujitsu.com>)
Responses RE: Time delayed LR (WAS Re: logical replication restrictions)
List pgsql-hackers
Hi,

On 2023-02-10 11:26:21 +0000, Takamichi Osumi (Fujitsu) wrote:
> Subject: [PATCH v34] Time-delayed logical replication subscriber
> 
> Similar to physical replication, a time-delayed copy of the data for
> logical replication is useful for some scenarios (particularly to fix
> errors that might cause data loss).
> 
> This patch implements a new subscription parameter called 'min_apply_delay'.

Sorry for not reading through the thread, but it's very long.


Has there been any discussion about whether this is actually best implemented
on the client side? You could alternatively implement it on the sender.

That'd have quite a few advantages, I think - you e.g. wouldn't remove the
ability to *receive* and send feedback messages.  We'd not end up filling up
the network buffer with data that we'll not process anytime soon.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Move defaults toward ICU in 16?
Next
From: Andrey Borodin
Date:
Subject: Re: UUID v7