Re: Logical replication timeout problem - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Logical replication timeout problem
Date
Msg-id 20230208183037.nbruzxin66guxsuj@awork3.anarazel.de
Whole thread Raw
In response to Re: Logical replication timeout problem  (Andres Freund <andres@anarazel.de>)
Responses Re: Logical replication timeout problem  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Hi,

On 2023-02-08 10:18:41 -0800, Andres Freund wrote:
> I don't think the syncrep logic in WalSndUpdateProgress really works as-is -
> consider what happens if e.g. the origin filter filters out entire
> transactions. We'll afaics never get to WalSndUpdateProgress(). In some cases
> we'll be lucky because we'll return quickly to XLogSendLogical(), but not
> reliably.

Is it actually the right thing to check SyncRepRequested() in that logic? It's
quite common to set up syncrep so that individual users or transactions opt
into syncrep, but to leave the default disabled.

I don't really see an alternative to making this depend solely on
sync_standbys_defined.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: recovery modules
Next
From: Matthias van de Meent
Date:
Subject: Re: Improving btree performance through specializing by key shape, take 2