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

Re: FDW for PostgreSQL

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com>,Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp>,Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: FDW for PostgreSQL
Date: 2013-03-28 16:20:44
Message-ID: 20130328162044.GT4361@tamriel.snowman.net (view raw or flat)
Thread:
Lists: pgsql-hackers
* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> I don't want to have API features that make connections
> explicit, because I don't think that can be shoehorned into the FDW
> model without considerable strain and weird corner cases.

It seems we're talking past each other here.  I'm not particularly
interested in exposing what connections have been made to other servers
via some API (though I could see some debugging use there).  What I was
hoping for is a way for a given user to say "I want this specific
change, to this table, to be persisted immediately".  I'd love to have
that ability *without* FDWs too.  It just happens that FDWs provide a
simple way to get there from here and without a lot of muddying of the
waters, imv.

FDWs are no stranger to remote connections which don't have transactions
either, file_fdw will happily return whatever the current contents of
the file are with no concern for PG transactions.  I would expect a
writable file_fdw to act the same and immediately write out any data
written to it.

Hope that clarifies things a bit.

	Thanks,

		Stephen

In response to

pgsql-hackers by date

Next:From: Kohei KaiGaiDate: 2013-03-28 16:33:24
Subject: Re: [sepgsql 1/3] add name qualified creation label
Previous:From: Alvaro HerreraDate: 2013-03-28 16:13:40
Subject: Re: sql_drop Event Triggerg

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