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

From Tom Lane
Subject Re: Join push-down for foreign tables
Date
Msg-id 17066.1314718142@sss.pgh.pa.us
Whole thread Raw
In response to Re: Join push-down for foreign tables  (Shigeru Hanada <shigeru.hanada@gmail.com>)
List pgsql-hackers
Shigeru Hanada <shigeru.hanada@gmail.com> writes:
> BTW, Is adding foreign server oid to RelOptInfo acceptable?

No objection here.

> This field
> is set in build_simple_rel() or build_join_rel() if the RelOptInfo
> itself is a foreign scan, or it is a foreign join and both inner and
> outer RelOptInfo have same and valid foreign server oid.

I think you mean "if all the base rels in the join rel come from the
same foreign server".
        regards, tom lane


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: compile from git repository
Next
From: Robert Haas
Date:
Subject: Re: Inputting relative datetimes