Re: The plan for FDW-based sharding

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Oleg Bartunov <obartunov(at)gmail(dot)com>
Cc: Josh berkus <josh(at)agliodbs(dot)com>, Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: The plan for FDW-based sharding
Date: 2016-03-11 12:33:16
Message-ID: 20160311123316.GA17237@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 11, 2016 at 10:19:16AM +0100, Oleg Bartunov wrote:
> Our XTM is the yet another example of infrastructure we need to work on
> clustering. Should we wait other smart guy starts thinking on distributed
> transactions ?  We described in https://wiki.postgresql.org/wiki/DTM our  API,
> which is just a wrapper on existed functions, but it will allow us and
> fortunately others to play with their ideas.  We did several prototypes,
> including FDW, to demonstrate viability of API, and plan to continue our work
> on built-in high availability, multi-master.  Of course, there will be a lot to
> learn, but it will be much easier if XTM will exists not as separate patch,
> which is really small.

I think everyone agrees we want a global transaction manager of some
type. I think choosing the one we want is the problem as there are
several possible directions.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mithun Cy 2016-03-11 12:44:08 Re: POC: Cache data in GetSnapshotData()
Previous Message Robert Haas 2016-03-11 12:32:48 Re: RFC: replace pg_stat_activity.waiting with something more descriptive