Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cjLBA-0006qn-HO for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Mar 2017 07:29:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cjLB9-0005bL-TA for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Mar 2017 07:29:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cjL9g-00030n-8f for pgsql-hackers@postgresql.org; Thu, 02 Mar 2017 07:28:04 +0000 Received: from mail.postgrespro.ru ([93.174.131.138]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cjL9Z-0007aZ-Sw for pgsql-hackers@postgresql.org; Thu, 02 Mar 2017 07:28:03 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 1298121C091A; Thu, 2 Mar 2017 10:27:56 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru Content-Type: text/plain; charset=utf-8 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1488439675; bh=Es3FUaufAaLHCUiU79fxpTb/xaAh+T0FjyRd9wiPQ/w=; h=Subject:From:In-Reply-To:Date:Cc:References:To; b=DBJ2Z5/geYffeEiOg7aWLfRq+K7hv842MPi+kU6caPQgXjjEpIqRCCVrI/+RdJGyW IV6bDnxtl+fuN7bZXlo0QdBztXNPAREYWcHhYwyU91EvTtZmMHCC9aJYtO716jZ7e+ uQyWLRcusCVh5RwTFZkc/PaqtLH2OAG61LBf/Q4w= Mime-Version: 1.0 (Mac OS X Mail 10.2 \(3259\)) Subject: Re: logical decoding of two-phase transactions From: Stas Kelvich In-Reply-To: <46ebc39d-82a0-e59f-2552-2ea8911a64e7@2ndquadrant.com> Date: Thu, 2 Mar 2017 10:27:51 +0300 Cc: Craig Ringer , Michael Paquier , PostgreSQL Hackers , Simon Riggs , Robert Haas , Tom Lane Content-Transfer-Encoding: quoted-printable Message-Id: References: <02DA5F5E-CECE-4D9C-8B4B-418077E2C010@postgrespro.ru> <89073436-925E-4299-A9AF-88D04E55C231@postgrespro.ru> <3477E635-F590-4432-BD20-C59142B65CD3@postgrespro.ru> <1FE466EA-7058-484D-B0DB-42CD81FA59F0@postgrespro.ru> <46ebc39d-82a0-e59f-2552-2ea8911a64e7@2ndquadrant.com> To: Petr Jelinek X-Mailer: Apple Mail (2.3259) X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org > On 2 Mar 2017, at 01:20, Petr Jelinek wrot= e: >=20 > 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. >=20 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=E2=80=99m failing to explain some points = about this topic. Or, maybe, I=E2=80=99m failing to understand some points. Can we may= be setup skype call to discuss this and post summary here? Craig? Peter? -- Stas Kelvich Postgres Professional: http://www.postgrespro.com The Russian Postgres Company --=20 Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers