Re: Status of FDW pushdowns - Mailing list pgsql-hackers

From David Fetter
Subject Re: Status of FDW pushdowns
Date
Msg-id 20131122013900.GB17414@fetter.org
Whole thread Raw
In response to Re: Status of FDW pushdowns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, Nov 21, 2013 at 10:46:14AM -0500, Tom Lane wrote:
> Merlin Moncure <mmoncure@gmail.com> writes:
> > On Thu, Nov 21, 2013 at 9:05 AM, Bruce Momjian <bruce@momjian.us> wrote:
> >> I know join pushdowns seem insignificant, but it helps to restrict what
> >> data must be passed back because you would only pass back joined rows.
> 
> > By 'insignificant' you mean 'necessary to do any non-trivial real
> > work'.   Personally, I'd prefer it if FDW was extended to allow
> > arbitrary parameterized queries like every other database connectivity
> > API ever made ever.
> 
> [ shrug... ]  So use dblink.

Not with a non-PostgreSQL data source.

> For better or worse, the FDW stuff is following the SQL standard's
> SQL/MED design, which does not do it like that.

What SQL/MED specifies along this line is purely a caution against
making a specification without a reference implementation.  If I'm
reading it correctly, it's literally impossible to make what they
suggest safe.

Given those givens, we're free to do this in a way that's not
barking-at-the-moon crazy.  At least two inter-database communication
links which work with PostgreSQL do this..

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate



pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: GSOC13 proposal - extend RETURNING syntax
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: psql should show disabled internal triggers