Commit 7012b13

committed

postgres_fdw: Push down aggregates to remote servers.

Now that the upper planner uses paths, and now that we have proper hooks to inject paths into the upper planning process, it's possible for foreign data wrappers to arrange to push aggregates to the remote side instead of fetching all of the rows and aggregating them locally. This figures to be a massive win for performance, so teach postgres_fdw to do it. Jeevan Chalke and Ashutosh Bapat. Reviewed by Ashutosh Bapat with additional testing by Prabhat Sahu. Various mostly cosmetic changes by me.

1 parent 709e461 commit 7012b13Copy full SHA for 7012b13

6 files changed

+2452

-150

lines changed

contrib/postgres_fdw
- deparse.c
- expected
  - postgres_fdw.out
- postgres_fdw.c
- postgres_fdw.h
- sql
  - postgres_fdw.sql
src/backend/optimizer/plan
- createplan.c

6 files changed

+2452

-150

lines changed

Comments

(0)

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit 7012b13

6 files changed

6 files changed

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier! Saves Data!

File tree

6 files changed

6 files changed

0 commit comments

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier! Saves Data!