pgsql: postgres_fdw: Push down joins to remote servers.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: postgres_fdw: Push down joins to remote servers.
Date: 2016-02-09 19:15:57
Message-ID: E1aTDlV-0007xw-Vj@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

postgres_fdw: Push down joins to remote servers.

If we've got a relatively straightforward join between two tables,
this pushes that join down to the remote server instead of fetching
the rows for each table and performing the join locally. Some cases
are not handled yet, such as SEMI and ANTI joins. Also, we don't
yet attempt to create presorted join paths or parameterized join
paths even though these options do get tried for a base relation
scan. Nevertheless, this seems likely to be a very significant win
in many practical cases.

Shigeru Hanada and Ashutosh Bapat, reviewed by Robert Haas, with
additional review at various points by Tom Lane, Etsuro Fujita,
KaiGai Kohei, and Jeevan Chalke.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/e4106b2528727c4b48639c0e12bf2f70a766b910

Modified Files
--------------
contrib/postgres_fdw/deparse.c | 531 +++++++++---
contrib/postgres_fdw/expected/postgres_fdw.out | 1094 ++++++++++++++++++++++--
contrib/postgres_fdw/postgres_fdw.c | 835 ++++++++++++++++--
contrib/postgres_fdw/postgres_fdw.h | 46 +-
contrib/postgres_fdw/sql/postgres_fdw.sql | 213 ++++-
doc/src/sgml/postgres-fdw.sgml | 10 +
6 files changed, 2464 insertions(+), 265 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2016-02-09 20:10:15 Re: pgsql: postgres_fdw: Push down joins to remote servers.
Previous Message Tom Lane 2016-02-09 16:21:52 pgsql: Add more chattiness in server shutdown.

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-02-09 19:16:22 Re: postgres_fdw join pushdown (was Re: Custom/Foreign-Join-APIs)
Previous Message Tom Lane 2016-02-09 19:10:50 Re: Tracing down buildfarm "postmaster does not shut down" failures