]> granicus.if.org Git - postgresql/commit
postgres_fdw: Perform the (ORDERED, NULL) upperrel operations remotely.
authorEtsuro Fujita <efujita@postgresql.org>
Tue, 2 Apr 2019 10:20:30 +0000 (19:20 +0900)
committerEtsuro Fujita <efujita@postgresql.org>
Tue, 2 Apr 2019 10:20:30 +0000 (19:20 +0900)
commitffab494a4d4676a71e830b2d7285eeeb5f2b53d7
treeaf36b3a1c38ba6099c960d272e864cc7e86d0988
parente2d28c0f404713f564dc2250646551c75172f17b
postgres_fdw: Perform the (ORDERED, NULL) upperrel operations remotely.

The upper-planner pathification allows FDWs to arrange to push down
different types of upper-stage operations to the remote side.  This
commit teaches postgres_fdw to do it for the (ORDERED, NULL) upperrel,
which is responsible for evaluating the query's ORDER BY ordering.
Since postgres_fdw is already able to evaluate that ordering remotely
for foreign baserels and foreign joinrels (see commit aa09cd242f et al.),
this adds support for that for foreign grouping relations.

Author: Etsuro Fujita
Reviewed-By: Antonin Houska and Jeff Janes
Discussion: https://postgr.es/m/87pnz1aby9.fsf@news-spur.riddles.org.uk
contrib/postgres_fdw/deparse.c
contrib/postgres_fdw/expected/postgres_fdw.out
contrib/postgres_fdw/postgres_fdw.c
contrib/postgres_fdw/postgres_fdw.h