Re: What is the extent of FDW join pushdown support in 9.5? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: What is the extent of FDW join pushdown support in 9.5?
Date
Msg-id 55F9D1F3.2060801@gmx.net
Whole thread Raw
In response to Re: What is the extent of FDW join pushdown support in 9.5?  (Kouhei Kaigai <kaigai@ak.jp.nec.com>)
Responses Re: What is the extent of FDW join pushdown support in 9.5?
List pgsql-hackers
On 9/15/15 10:02 PM, Kouhei Kaigai wrote:
>> The 9.5 release notes contain this promising but cryptic item:
>>
>> - Allow foreign data wrappers and custom scans to implement join
>> pushdown (KaiGai Kohei)
>>
>> As phrased, this seems to mean, "it can be done, but we haven't done
>> it".  But there is no link to any documentation that explains how to do
>> this.  The commit that appears to have added this feature touches
>> postgres_fdw, but neither the documentation nor the tests show anything
>> about this feature, and I haven't been able to reproduce anything that
>> would seem to indicate anything like this is at work.
>>
>> So what is the actual extent of this feature?
>>
> It says these enhancement on interface allows extensions to implement
> join operation in their own way (including remote join in case of FDW),
> however, enhancement of postgres_fdw is not yet upstreamed.

Thank you for this clarification.  I suppose this item is correct as
written.




pgsql-hackers by date:

Previous
From: "ktm@rice.edu"
Date:
Subject: Re: Reliance on undefined behaviour in << operator
Next
From: Peter Eisentraut
Date:
Subject: Re: hot_standby_feedback default and docs