postgres_fdw: Perform the (ORDERED, NULL) upperrel operations remotely.
Etsuro Fujita <efujita@postgresql.org>
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
Files
| Path | Change | +/− |
|---|---|---|
| contrib/postgres_fdw/deparse.c | modified | +21 −7 |
| contrib/postgres_fdw/expected/postgres_fdw.out | modified | +66 −101 |
| contrib/postgres_fdw/postgres_fdw.c | modified | +359 −29 |
| contrib/postgres_fdw/postgres_fdw.h | modified | +11 −1 |
Discussion
- Problems with plan estimates in postgres_fdw 48 messages · 2018-08-02 → 2019-04-02