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

From Stas Kelvich
Subject Re: logical decoding of two-phase transactions
Date
Msg-id 9CD693AF-51BE-4A19-9D26-16031CDAD9C9@postgrespro.ru
Whole thread Raw
In response to Re: logical decoding of two-phase transactions  (Stas Kelvich <s.kelvich@postgrespro.ru>)
Responses Re: logical decoding of two-phase transactions  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
> On 4 Apr 2017, at 04:23, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>
>
> I reviewed this patch but when I tried to build contrib/test_decoding
> I got the following error.
>

Thanks!

Yes, seems that 18ce3a4a changed ProcessUtility_hook signature.
Updated.

> There are still some unnecessary code in v5 patch.

Actually second diff isn’t intended to be part of the patch, I've just shared
the way I ran regression test suite through the 2pc decoding changing
all commits to prepare/commits where commits happens only after decoding
of prepare is finished (more details in my previous message in this thread).

That is just argument against Andres concern that prepared transaction
is able to deadlock with decoding process — at least no such cases in
regression tests.

And that concern is main thing blocking this patch. Except explicit catalog
locks in prepared tx nobody yet found such cases and it is hard to address
or argue about.

Stas Kelvich
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


Attachment

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Compiler warning in costsize.c
Next
From: Anastasia Lubennikova
Date:
Subject: Re: WIP: Covering + unique indexes.