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

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-13 08:00:37
Message-ID: OSBPR01MB48882306C2E5FBBADEB24748ED6E9@OSBPR01MB4888.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

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.

In my env, I checked those and the results were fine, though.

Best Regards,
Takamichi Osumi

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2021-03-13 08:08:31 Re: pgbench: option delaying queries till connections establishment?
Previous Message Tom Lane 2021-03-13 07:36:39 Re: pg_amcheck contrib application