Skip site navigation (1) Skip section navigation (2)

Re: Transactions involving multiple postgres foreign servers

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Vinayak Pokale <vinpokale(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
Subject: Re: Transactions involving multiple postgres foreign servers
Date: 2016-10-31 00:47:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Fri, Oct 28, 2016 at 3:19 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Wed, Oct 26, 2016 at 2:00 AM, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>> I think we can consider the atomic commit and the atomic visibility
>> separately, and the atomic visibility can build on the top of the
>> atomic commit.
> It is true that we can do that, but I'm not sure whether it's the best design.

I'm not sure best design, too. We need to discuss more. But this is
not a particular feature for the sharing solution. The atomic commit
using 2PC is useful for other servers that can use 2PC, not only

Attached latest 3 patches that incorporated review comments so far.
But recovery speed improvement that is discussed on another thread is
not incorporated yet.
Please give me feedback.


Masahiko Sawada
NTT Open Source Software Center

Attachment: 000_support_fdw_xact_v2.patch
Description: application/octet-stream (105.8 KB)
Attachment: 002_pg_fdw_resolver_v2.patch
Description: application/octet-stream (11.1 KB)
Attachment: 001_pg_fdw_supports_2pc_v2.patch
Description: application/octet-stream (25.5 KB)

In response to


pgsql-hackers by date

Next:From: Kyotaro HORIGUCHIDate: 2016-10-31 00:59:15
Subject: Re: Radix tree for character conversion
Previous:From: Steve SingerDate: 2016-10-30 23:52:41
Subject: Re: Logical Replication WIP

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group