2013/11/22 Kohei KaiGai <kai...@kaigai.gr.jp>: > 2013/11/21 Bruce Momjian <br...@momjian.us>: >> Where are we on the remaining possible pushdowns for foreign data >> wrappers, particularly the Postgres one? I know we do WHERE restriction >> pushdowns in 9.3, but what about join and aggregate pushdowns? Is >> anyone working on those? >> >> I know join pushdowns seem insignificant, but it helps to restrict what >> data must be passed back because you would only pass back joined rows. >> >> Do we document these missing features anywhere? >> > Probably, custom-scan api will provide more flexible way to push-down > aggregate, sort or other stuff performing on regular tables, not only > foreign tables. > It allows extensions to offer alternative scan/join path on the planning > stage, then executor callbacks its custom logic instead of the built-in > one, if its cost is cheaper.
IIRC, sort push-down is already supported. We can provide sorted pathes by setting Pathkeys to additional ForeignPath. postgres_fdw doesn't support this feature because we couldn't get consensus about how to limit sort variation. One idea was to allow to define "foreign index" on foreign tables to indicate which column combination is reasonably sortable. -- Shigeru HANADA -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
