Content-Length: 252696 | pFad | http://github.com/postgrespro/postgres_cluster/commit/e4106b2528727c4b48639c0e12bf2f70a766b910

2B postgres_fdw: Push down joins to remote servers. · postgrespro/postgres_cluster@e4106b2 · GitHub
Skip to content

Commit e4106b2

Browse files
robertmhaasrobertmhaas
committed
postgres_fdw: Push down joins to remote servers.
If we've got a relatively straightforward join between two tables, this pushes that join down to the remote server instead of fetching the rows for each table and performing the join locally. Some cases are not handled yet, such as SEMI and ANTI joins. Also, we don't yet attempt to create presorted join paths or parameterized join paths even though these options do get tried for a base relation scan. Nevertheless, this seems likely to be a very significant win in many practical cases. Shigeru Hanada and Ashutosh Bapat, reviewed by Robert Haas, with additional review at various points by Tom Lane, Etsuro Fujita, KaiGai Kohei, and Jeevan Chalke.
1 parent 7351e18 commit e4106b2

File tree

6 files changed

+2464
-265
lines changed

6 files changed

+2464
-265
lines changed

0 commit comments

Comments
 (0)








ApplySandwichStrip

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


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres_cluster/commit/e4106b2528727c4b48639c0e12bf2f70a766b910

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy