RE: [HACKERS] logical decoding of two-phase transactions

Поиск
Список
Период
Сортировка
От osumi.takamichi@fujitsu.com
Тема RE: [HACKERS] logical decoding of two-phase transactions
Дата
Msg-id OSBPR01MB4888930C23E17AF29EDB9D82ED689@OSBPR01MB4888.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на [HACKERS] logical decoding of two-phase transactions  (Stas Kelvich <s.kelvich@postgrespro.ru>)
Список pgsql-hackers
Hi


On Saturday, March 13, 2021 5:01 PM osumi.takamichi@fujitsu.com <osumi.takamichi@fujitsu.com> wrote:
> On Friday, March 12, 2021 5:40 PM Peter Smith <smithpb2250@gmail.com>
> > Please find attached the latest patch set v58*
> Thank you for updating those. I'm testing the patchset and I think it's
> preferable that you add simple two types of more tests in 020_twophase.pl
> because those aren't checked by v58.
> 
> (1) execute single PREPARE TRANSACTION
>     which affects several tables (connected to corresponding
> publications)
>     at the same time and confirm they are synced correctly.
> 
> (2) execute single PREPARE TRANSACTION which affects multiple
> subscribers
>     and confirm they are synced correctly.
>     This doesn't mean cascading standbys like
> 022_twophase_cascade.pl.
>     Imagine that there is one publisher and two subscribers to it.
Attached a patch for those two tests. The patch works with v62.
I tested this in a loop more than 100 times and showed no failure.

Best Regards,
    Takamichi Osumi


Вложения

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: libpq compression
Следующее
От: "tsunakawa.takay@fujitsu.com"
Дата:
Сообщение: RE: Disable WAL logging to speed up data loading