|From:||Robert Haas <rhaas(at)postgresql(dot)org>|
|Subject:||pgsql: postgres_fdw: Consider foreign joining and foreign sorting toget|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
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.
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(-)
|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.|