Re: Foreign join pushdown vs EvalPlanQual

From: Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Kouhei Kaigai <kaigai(at)ak(dot)jp(dot)nec(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com>
Subject: Re: Foreign join pushdown vs EvalPlanQual
Date: 2015-11-19 03:54:39
Message-ID: 564D47FF.8070300@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2015/11/19 12:34, Robert Haas wrote:
> On Tue, Nov 17, 2015 at 9:30 PM, Etsuro Fujita
> <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp> wrote:
>> I suppose you (and KaiGai-san) are probably right, but I really fail to see
>> it actually doing that.

> Noted, but let's do it that way and move on. It would be a shame if
> we didn't end up with a working FDW join pushdown system in 9.6
> because of a disagreement on this point.

Another idea would be to consider join pushdown as unsupported for now
when select-for-update is involved in 9.5, as described in [1], and
revisit this issue when adding join pushdown to postgres_fdw in 9.6.

Best regards,
Etsuro Fujita

[1] https://wiki.postgresql.org/wiki/Open_Items

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2015-11-19 03:58:58 Re: [COMMITTERS] pgsql: Improve vcregress.pl's handling of tap tests for client programs
Previous Message Andrew Dunstan 2015-11-19 03:51:54 pgsql: Improve vcregress.pl's handling of tap tests for client programs