pg.ddx.io pgsql-hackers@postgresql.org mailing list archive help / color / mirror / Atom feed From: Stas Kelvich <s.kelvich@postgrespro.ru>
To: Petr Jelinek <petr.jelinek@2ndquadrant.com>
Cc: Craig Ringer <craig@2ndquadrant.com>
Cc: Michael Paquier <michael.paquier@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: logical decoding of two-phase transactions
Date: Thu, 2 Mar 2017 10:27:51 +0300
Message-ID: <DFE91C41-1410-4D89-B7D6-819F5FDC1437@postgrespro.ru> (raw )
In-Reply-To: <46ebc39d-82a0-e59f-2552-2ea8911a64e7@2ndquadrant.com >
References: <02DA5F5E-CECE-4D9C-8B4B-418077E2C010@postgrespro.ru >
<CANP8+jJGRpczm8L=LQCzuiEG3qHbY1cQB+T4A-cct7xgFmjj9g@mail.gmail.com >
<CANP8+jJ+=hwLcDSNAqBmZwHh0Pb46SERQsBC1i4VCpkgkL9Jjg@mail.gmail.com >
<D11D3072-6A72-439C-8B62-1D2628134A60@postgrespro.ru >
<CANP8+j+xxYB5GoFebq1NGm17TEAaZ=JvM-Ok-Hp+n6De3pseeA@mail.gmail.com >
<DED204B8-0877-4BAB-B2FE-0F450BD56186@postgrespro.ru >
<CAMsr+YH0aRgnk8XwyYypV1E10DNXwgGpWTLq_P2MGjACpiwMpA@mail.gmail.com >
<89073436-925E-4299-A9AF-88D04E55C231@postgrespro.ru >
<CAMsr+YGX6Q-VNXEhu3sriCf0wCS6hjQ0Lhj4rJ8VueVuuka+fg@mail.gmail.com >
<3477E635-F590-4432-BD20-C59142B65CD3@postgrespro.ru >
<CAMsr+YHos95GFyfd2Gk61-66wpxFTgXJh=sBV3Rtfhe3xzG1HQ@mail.gmail.com >
<CAB7nPqQogmPYRkb=wwA4veeAWZXwDXQA64vw7fO_mHuDhAOHoA@mail.gmail.com >
<CAMsr+YHQzGxnR-peT4SbX2-xiG2uApJMTgZ4a3TiRBM6COyfqg@mail.gmail.com >
<1FE466EA-7058-484D-B0DB-42CD81FA59F0@postgrespro.ru >
<CAMsr+YHVNW-Lh-XnYnkfhGL2QT8kK9kM4zkZ4+Sv=fszhujj-g@mail.gmail.com >
<46ebc39d-82a0-e59f-2552-2ea8911a64e7@2ndquadrant.com >
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
> On 2 Mar 2017, at 01:20, Petr Jelinek <petr.jelinek@2ndquadrant.com> wrote:
>
> The info gets removed on COMMIT PREPARED but at that point
> there is no real difference between replicating it as 2pc or 1pc since
> the 2pc behavior is for all intents and purposes lost at that point.
>
If we are doing 2pc and COMMIT PREPARED happens then we should
replicate that without transaction body to the receiving servers since tx
is already prepared on them with some GID. So we need a way to construct
that GID.
It seems that last ~10 messages I’m failing to explain some points about this
topic. Or, maybe, I’m failing to understand some points. Can we maybe setup
skype call to discuss this and post summary here? Craig? Peter?
--
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
view thread (644+ messages) latest in thread
Message-ID: <DFE91C41-1410-4D89-B7D6-819F5FDC1437@postgrespro.ru>
Permalink: ../DFE91C41-1410-4D89-B7D6-819F5FDC1437@postgrespro.ru/
Also on: postgresql.org/message-id/DFE91C41-1410-4D89-B7D6-819F5FDC1437@postgrespro.ru
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: s.kelvich@postgrespro.ru, petr.jelinek@2ndquadrant.com, craig@2ndquadrant.com, michael.paquier@gmail.com, simon@2ndquadrant.com, robertmhaas@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: logical decoding of two-phase transactions
In-Reply-To: <DFE91C41-1410-4D89-B7D6-819F5FDC1437@postgrespro.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox