RE: [HACKERS] logical decoding of two-phase transactions - Mailing list pgsql-hackers

From osumi.takamichi@fujitsu.com
Subject RE: [HACKERS] logical decoding of two-phase transactions
Date
Msg-id OSBPR01MB4888930C23E17AF29EDB9D82ED689@OSBPR01MB4888.jpnprd01.prod.outlook.com
Whole thread Raw
In response to [HACKERS] logical decoding of two-phase transactions  (Stas Kelvich <s.kelvich@postgrespro.ru>)
List 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


Attachment

pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: libpq compression
Next
From: "tsunakawa.takay@fujitsu.com"
Date:
Subject: RE: Disable WAL logging to speed up data loading