Re: Decoding of two-phase xacts missing from CREATE_REPLICATION_SLOT command

From: Ajin Cherian <itsajin(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Amit Kapila <akapila(at)postgresql(dot)org>, vignesh C <vignesh21(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>
Subject: Re: Decoding of two-phase xacts missing from CREATE_REPLICATION_SLOT command
Date: 2021-06-10 08:34:15
Message-ID: CAFPTHDZQ0DefQP1UakkBSP5cwP1y8e4_HqzJjQ3edW-q8aSLEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 9, 2021 at 9:57 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Wed, Jun 9, 2021 at 4:50 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >
> > On Wed, Jun 9, 2021 at 1:53 AM Jeff Davis <pgsql(at)j-davis(dot)com> wrote:
> > >
> > > On Tue, 2021-06-08 at 17:41 +1000, Ajin Cherian wrote:
> > > > Here's an updated patchset that adds back in the option for two-phase
> > > > in CREATE_REPLICATION_SLOT command and a second patch that adds
> > > > support for
> > > > two-phase decoding in pg_recvlogical.
> > >
> > > A few things:
> > >
> > > * I suggest putting the TWO_PHASE keyword after the LOGICAL keyword
> > >
> >
> > Isn't it better to add it after LOGICAL IDENT? In docs [1], we expect
> > that way. Also, see code in libpqrcv_create_slot where we expect them
> > to be together but we can change that if you still prefer to add it
> > after LOGICAL. BTW, can't we consider it to be part of
> > create_slot_opt_list?

Changed accordingly.

> Some more points:
> 1. pg_recvlogical can only send two_phase option if
> (PQserverVersion(conn) >= 140000), otherwise, it won't work for older
> versions of the server.

Updated accordingly.

I've also modified the pg_recvlogical test case with the new option.

regards,
Ajin Cherian

Attachment Content-Type Size
v4-0001-Add-option-to-set-two-phase-in-CREATE_REPLICATION.patch application/octet-stream 6.5 KB
v4-0002-Add-support-for-two-phase-decoding-in-pg_recvlogi.patch application/octet-stream 11.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2021-06-10 08:42:25 Re: Decoding speculative insert with toast leaks memory
Previous Message Peter Eisentraut 2021-06-10 08:31:37 Re: "an SQL" vs. "a SQL"