Re: [HACKERS] logical decoding of two-phase transactions - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: [HACKERS] logical decoding of two-phase transactions
Date
Msg-id CAA4eK1Lt2SfanC-mTq-oM1-sZon1zF43Vc5YcXccpa1aNm0V3g@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] logical decoding of two-phase transactions  (Peter Smith <smithpb2250@gmail.com>)
Responses Re: [HACKERS] logical decoding of two-phase transactions  (Peter Smith <smithpb2250@gmail.com>)
Re: [HACKERS] logical decoding of two-phase transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] logical decoding of two-phase transactions  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
On Mon, Jul 12, 2021 at 9:14 AM Peter Smith <smithpb2250@gmail.com> wrote:
>
> On Sun, Jul 11, 2021 at 8:20 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> >
> > On Fri, Jul 9, 2021 at 4:43 AM Peter Smith <smithpb2250@gmail.com> wrote:
> > >
> > > > The patch looks good to me, I don't have any comments.
> > >
> > > I tried the v95-0001 patch.
> > >
> > > - The patch applied cleanly and all build / testing was OK.
> > > - The documentation also builds OK.
> > > - I checked all v95-0001 / v93-0001 differences and found no problems.
> > > - Furthermore, I noted that v95-0001 patch is passing the cfbot [1].
> > >
> > > So this patch LGTM.
> > >
> >
> > Thanks, I took another pass over it and made a few changes in docs and
> > comments. I am planning to push this next week sometime (by 14th July)
> > unless there are more comments from you or someone else. Just to
> > summarize, this patch will add support for prepared transactions to
> > built-in logical replication. To add support for streaming
> > transactions at prepare time into the
> > built-in logical replication, we need to do the following things: (a)
> > Modify the output plugin (pgoutput) to implement the new two-phase API
> > callbacks, by leveraging the extended replication protocol. (b) Modify
> > the replication apply worker, to properly handle two-phase
> > transactions by replaying them on prepare. (c) Add a new SUBSCRIPTION
> > option "two_phase" to allow users to enable
> > two-phase transactions. We enable the two_phase once the initial data
> > sync is over. Refer to comments atop worker.c in the patch and commit
> > message to see further details about this patch. After this patch,
> > there is a follow-up patch to allow streaming and two-phase options
> > together which I feel needs some more review and can be committed
> > separately.
> >
>
> FYI - I repeated the same verification of the v96-0001 patch as I did
> previously for v95-0001
>
> - The v96 patch applied cleanly and all build / testing was OK.
> - The documentation also builds OK.
> - I checked the v95-0001 / v96-0001 differences and found no problems.
> - Furthermore, I noted that v96-0001 patch is passing the cfbot.
>
> LGTM.
>

Pushed.

Feel free to submit the remaining patches after rebase. Is it possible
to post patches related to skipping empty transactions in the other
thread [1] where that topic is being discussed?

[1] - https://www.postgresql.org/message-id/CAMkU%3D1yohp9-dv48FLoSPrMqYEyyS5ZWkaZGD41RJr10xiNo_Q%40mail.gmail.com

-- 
With Regards,
Amit Kapila.



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: printf %s with NULL pointer (was Re: BUG #17098: Assert failed on composing an error message when adding a type to an extension being dropped)
Next
From: Daniel Gustafsson
Date:
Subject: Re: Remove repeated calls to PQserverVersion