Re: Logical Replication vs. 2PC

Поиск
Список
Период
Сортировка
От Ajin Cherian
Тема Re: Logical Replication vs. 2PC
Дата
Msg-id CAFPTHDYeXL7aHWUW41drP7zWvOE4OdbzSzqcVK-dy8c3DELsPA@mail.gmail.com
обсуждение исходный текст
Ответ на Logical Replication vs. 2PC  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers


On Thu, Mar 18, 2021 at 8:46 PM Amit Kapila <amit.kapila16@gmail.com> wrote:


However, if the user has setup synchronous_standby_names for all the
subscriptions then we won't be able to proceed because the prepare on
publisher will wait for all the subscriptions to ack and the
subscriptions are waiting for the first prepare to finish. 

But is it a valid use case to have two synchronous standbys which are two subscriptions that are on the same server both with 2pc enabled?
If the purpose of synchronous standby is for durability to prevent data loss, then why split your tables across 2 subscriptions which are on the same server?
Maybe it could be documented warning users from having such a setup. Do we really want to create a solution for an impractical scenario?

regards,
Ajin Cherian
Fujitsu Australia

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Parallel Inserts in CREATE TABLE AS
Следующее
От:
Дата:
Сообщение: RE: Wrong statistics for size of XLOG_SWITCH during pg_waldump.