RE: locking [user] catalog tables vs 2pc vs logical rep

From: "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>
To: 'Amit Kapila' <amit(dot)kapila16(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>
Cc: Peter Smith <smithpb2250(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Markus Wanner <markus(dot)wanner(at)enterprisedb(dot)com>
Subject: RE: locking [user] catalog tables vs 2pc vs logical rep
Date: 2021-06-08 08:03:59
Message-ID: OSBPR01MB4888660F2E19C28673FC5A9CED379@OSBPR01MB4888.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Monday, June 7, 2021 6:22 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> On Mon, Jun 7, 2021 at 10:44 AM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
> wrote:
> >
> > One more comment is that for HEAD, first just create a patch with
> > synchronous replication-related doc changes and then write a separate
> > patch for prepared transactions.
> >
>
> I noticed that docs for "Synchronous replication support for Logical Decoding"
> has been introduced by commit
> 49c0864d7ef5227faa24f903902db90e5c9d5d69 which goes till 9.6. So, I think
> you need to create a patch for 9.6 as well unless one of the existing patches
> already applies in 9.6.
OK. I could apply PG10's patch to 9.6.
Also, I've made a separate patch for 2PC description.

On the other hand, I need to mention that
there are some gaps to cause failures to apply patches
between supported versions.
(e.g. applying a patch for HEAD to stable PG13 fails)

To address the gaps between the versions,
I needed to conduct some manual fixes.
Therefore, please note that the content of patch
between PG12 and PG13 are almost same
like PG9.6 and PG10, but, I prepared
independent patches for HEAD and PG11,
in order to make those applied in a comfortable manner.

Kindly have a look at the updated patch-set.
They all passed the test of make html.

Best Regards,
Takamichi Osumi

Attachment Content-Type Size
HEAD_deadlock_documentation_of_logical_decoding_v04.patch application/octet-stream 3.9 KB
HEAD_with_2PC_deadlock_documentation_of_logical_decoding_v04.patch application/octet-stream 1.9 KB
PG10_deadlock_documentation_of_logical_decoding_v04.patch application/octet-stream 3.8 KB
PG11_deadlock_documentation_of_logical_decoding_v04.patch application/octet-stream 3.8 KB
PG12_deadlock_documentation_of_logical_decoding_v04.patch application/octet-stream 3.8 KB
PG13_deadlock_documentation_of_logical_decoding_v04.patch application/octet-stream 3.8 KB
PG96_deadlock_documentation_of_logical_decoding_v04.patch application/octet-stream 3.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro Horiguchi 2021-06-08 08:09:58 Re: Transactions involving multiple postgres foreign servers, take 2
Previous Message Ajin Cherian 2021-06-08 07:41:06 Re: Decoding of two-phase xacts missing from CREATE_REPLICATION_SLOT command