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

Amit Kapila <amit.kapila16@gmail.com>

From: Amit Kapila <amit.kapila16@gmail.com>
To: "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Cc: Simon Riggs <simon.riggs@enterprisedb.com>, vignesh C <vignesh21@gmail.com>, Peter Smith <smithpb2250@gmail.com>, Andres Freund <andres@anarazel.de>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Markus Wanner <markus.wanner@enterprisedb.com>
Date: 2021-06-24T09:32:15Z
Lists: pgsql-hackers
On Mon, Jun 21, 2021 at 8:48 AM osumi.takamichi@fujitsu.com
<osumi.takamichi@fujitsu.com> wrote:
>
> On Sunday, June 20, 2021 9:50 PM I wrote:
> > On Sunday, June 20, 2021 3:23 PM  Amit Kapila <amit.kapila16@gmail.com>
> > wrote:
> > > On Sun, Jun 20, 2021 at 9:28 AM osumi.takamichi@fujitsu.com
> > > <osumi.takamichi@fujitsu.com> wrote:
> > > > * doc/src/sgml/logicaldecoding.sgml
> > ...
> > > >
> > > > Now we have the four paren supplementary descriptions, not to make
> > > > users miss any other [user] catalog tables.
> > > > Because of this, the built output html gives me some redundant
> > > > impression, for that parts. Accordingly, couldn't we move them to
> > > > outside of the itemizedlist section in a simple manner ?
> > > >
> > > > For example, to insert a sentence below the list, after removing the
> > > > paren descriptions in the listitem, which says "Note that those
> > > > commands that can cause deadlock apply to not only explicitly
> > > > indicated system catalog tables above but also any other [user] catalog
> > table."
> > >
> > > Sounds reasonable to me. /but also any other/but also to any other/,
> > > to seems to be missing in the above line. Kindly send an update patch.
> > Excuse me, I don't understand the second sentence.
> > I wrote "but also" clause in my example.
> >
> > Also, attached the patch for the change to the HEAD.
> I've updated the patch to follow the correction Amit-san mentioned.
> Please check.
>

Pushed.

-- 
With Regards,
Amit Kapila.



Commits

  1. Doc: Update caveats in synchronous logical replication.

  2. Document a few caveats in synchronous logical replication.

  3. Update the docs and comments for decoding of prepared xacts.

  4. Allow decoding at prepare time in ReorderBuffer.

  5. Documentation for logical decoding.