From: | "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com> |
---|---|
To: | 'Peter Smith' <smithpb2250(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | RE: [HACKERS] logical decoding of two-phase transactions |
Date: | 2021-03-19 06:48:52 |
Message-ID: | OSBPR01MB4888930C23E17AF29EDB9D82ED689@OSBPR01MB4888.jpnprd01.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi
On Saturday, March 13, 2021 5:01 PM osumi(dot)takamichi(at)fujitsu(dot)com <osumi(dot)takamichi(at)fujitsu(dot)com> wrote:
> On Friday, March 12, 2021 5:40 PM Peter Smith <smithpb2250(at)gmail(dot)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 | Content-Type | Size |
---|---|---|
0001-add-2-types-of-new-tests-for-2PC.patch | application/octet-stream | 5.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | tsunakawa.takay@fujitsu.com | 2021-03-19 06:53:29 | RE: Disable WAL logging to speed up data loading |
Previous Message | Justin Pryzby | 2021-03-19 06:28:00 | Re: libpq compression |