From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp>, Denis Lussier <denis(dot)lussier(at)openscg(dot)com> |
Subject: | Re: Status of FDW pushdowns |
Date: | 2013-11-22 14:25:05 |
Message-ID: | CAHyXU0z0QFgCM1rxm4URQ10bb1BoPbUs5UxPhxHqhJPazXE2tg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Nov 21, 2013 at 6:43 PM, Shigeru Hanada
<shigeru(dot)hanada(at)gmail(dot)com> wrote:
> 2013/11/22 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>> Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
>>> On Thu, Nov 21, 2013 at 9:05 AM, Bruce Momjian <bruce(at)momjian(dot)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. For better or worse, the FDW stuff is
>> following the SQL standard's SQL/MED design, which does not do it
>> like that.
>
> Pass-through mode mentioned in SQL/MED standard might be what he wants.
happen to have a link handy?
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2013-11-22 14:31:39 | Re: new unicode table border styles for psql |
Previous Message | Jim Mlodgenski | 2013-11-22 14:20:42 | Re: Custom Scan APIs (Re: Custom Plan node) |