]> granicus.if.org Git - postgresql/commit
postgres_fdw: Push down joins to remote servers.
authorRobert Haas <rhaas@postgresql.org>
Tue, 9 Feb 2016 19:00:50 +0000 (14:00 -0500)
committerRobert Haas <rhaas@postgresql.org>
Tue, 9 Feb 2016 19:00:50 +0000 (14:00 -0500)
commite4106b2528727c4b48639c0e12bf2f70a766b910
treed22a96438d65f4cdd6537ab7787296e6bf14b190
parent7351e18286ec83461b386e23328d65fd4a538bba
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.
contrib/postgres_fdw/deparse.c
contrib/postgres_fdw/expected/postgres_fdw.out
contrib/postgres_fdw/postgres_fdw.c
contrib/postgres_fdw/postgres_fdw.h
contrib/postgres_fdw/sql/postgres_fdw.sql
doc/src/sgml/postgres-fdw.sgml