Re: Join push-down support for foreign tables - Mailing list pgsql-hackers

From Shigeru Hanada
Subject Re: Join push-down support for foreign tables
Date
Msg-id CAEZqfEfCaWmukO9wMg92kuSKbCQp0wLtMp1K4jrkTn+KrANT+g@mail.gmail.com
Whole thread Raw
In response to Re: Join push-down support for foreign tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
2014-12-16 0:45 GMT+09:00 Tom Lane <tgl@sss.pgh.pa.us>:
> Shigeru Hanada <shigeru.hanada@gmail.com> writes:
>> I'm working on $SUBJECT and would like to get comments about the
>> design.  Attached patch is for the design below.  Note that the patch
>> requires Kaigai-san's custom foriegn join patch[1]
>
> For the record, I'm not particularly on-board with custom scan, and
> even less so with custom join.  I don't want FDW features like this
> depending on those kluges, especially not when you're still in need
> of core-code changes (which really points up the inadequacy of those
> concepts).

This design derived from discussion about custom scan/join.  In that
discussion Robert suggested common infrastructure for replacing Join
path with Scan node.  Here I agree to user such common infrastructure.
One concern is introducing hook function I/F which seems to break
FdwRoutine I/F boundary...

>
> Also, please don't redefine struct NestPath like that.  That adds a
> whole bunch of notational churn (and backpatch risk) for no value
> that I can see.  It might've been better to do it like that in a
> green field, but you're about twenty years too late to do it now.

Ok, will revert it.

-- 
Shigeru HANADA



pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: group locking: incomplete patch, just for discussion
Next
From: Shigeru Hanada
Date:
Subject: Re: Join push-down support for foreign tables