Re: locking [user] catalog tables vs 2pc vs logical rep - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: locking [user] catalog tables vs 2pc vs logical rep
Date
Msg-id CAA4eK1LmJamH6tKhCFmzdUHNEKr2ofVaGx_WQGy+1wsN+kPNhA@mail.gmail.com
Whole thread Raw
In response to RE: locking [user] catalog tables vs 2pc vs logical rep  ("osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>)
Responses Re: locking [user] catalog tables vs 2pc vs logical rep
RE: locking [user] catalog tables vs 2pc vs logical rep
List pgsql-hackers
On Mon, Jun 14, 2021 at 5:33 PM osumi.takamichi@fujitsu.com
<osumi.takamichi@fujitsu.com> wrote:
>
> On  Friday, June 11, 2021 2:13 PM  vignesh C <vignesh21@gmail.com> wrote:
>
> Attached the patch-set that addressed those two comments.
>

Few minor comments:
1.
+      <listitem>
+       <para>
+        Clustering <structname>pg_class</structname> in a transaction.

Can we change above to: Perform <command>CLUSTER</command> on
<structname>pg_class</structname> in a transaction.

2.
+      <listitem>
+       <para>
+        Executing <command>TRUNCATE</command> on user catalog table
in a transaction.
+       </para>

Square brackets are missing for user.

3.
+    <indexterm>
+     <primary>Overview</primary>
+    </indexterm>
..
..
+    <indexterm>
+     <primary>Caveats</primary>
+    </indexterm>

Why are these required when we already have titles? I have seen other
places in the docs where we use titles for Overview and Caveats but
they didn't have similar usage.


4.
<para>
+        Performing <command>PREPARE TRANSACTION</command> after
<command>LOCK</command>
+        command on <structname>pg_class</structname> and logical
decoding of published
+        table.

Can we change above to: <command>PREPARE TRANSACTION</command> after
<command>LOCK</command> command on <structname>pg_class</structname>
and allow logical decoding of two-phase transactions.

5.
+       <para>
+        Clustering <structname>pg_trigger</structname> and decoding
<command>PREPARE
+        TRANSACTION</command>, if any published table have a trigger and any
+        operations that will be decoded are conducted.
+       </para>

Can we change above to: <command>PREPARE TRANSACTION</command> after
<command>CLUSTER</command> command on
<structname>pg_trigger</structname> and allow logical decoding of
two-phase transactions. This will lead to deadlock only when published
table have a trigger.

-- 
With Regards,
Amit Kapila.



pgsql-hackers by date:

Previous
From: Boris Kolpackov
Date:
Subject: Pipeline mode and PQpipelineSync()
Next
From: Greg Nancarrow
Date:
Subject: Issue with some calls to GetMultiXactIdMembers()