pgsql: postgres_fdw: Consider foreign joining and foreign sorting toget

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: postgres_fdw: Consider foreign joining and foreign sorting toget
Date: 2016-03-09 15:52:14
Message-ID: E1adgPG-00075x-2M@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

postgres_fdw: Consider foreign joining and foreign sorting together.

Commit ccd8f97922944566d26c7d90eb67ab7848ee9905 gave us the ability to
request that the remote side sort the data, and, later, commit
e4106b2528727c4b48639c0e12bf2f70a766b910 gave us the ability to
request that the remote side perform the join for us rather than doing
it locally. But we could not do both things at the same time: a
remote SQL query that had an ORDER BY clause would never be a join.
This commit adds that capability.

Ashutosh Bapat, reviewed by me.

Branch
------
master

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

Modified Files
--------------
contrib/postgres_fdw/expected/postgres_fdw.out | 303 +++++++++++++------------
contrib/postgres_fdw/postgres_fdw.c | 120 +++++++---
contrib/postgres_fdw/sql/postgres_fdw.sql | 5 +
3 files changed, 240 insertions(+), 188 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2016-03-09 15:57:01 pgsql: Fix incorrect tlist generation in create_gather_plan().
Previous Message Tom Lane 2016-03-09 15:29:21 pgsql: Fix copy-and-pasteo in comment.