Re: Logical replication timeout problem

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Logical replication timeout problem
Дата
Msg-id 20230208183037.nbruzxin66guxsuj@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: Logical replication timeout problem  (Andres Freund <andres@anarazel.de>)
Ответы Re: Logical replication timeout problem
Список 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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: recovery modules
Следующее
От: Matthias van de Meent
Дата:
Сообщение: Re: Improving btree performance through specializing by key shape, take 2