search

snaga / monetdb_fdw

monetdb_fdw - PostgreSQL Foreign Data Wrapper for MonetDB
http://pgsnaga.blogspot.jp/2013/07/monetdbfdw-postgresql-meets-column.html
Other
40 stars 6 forks source link

No filter nor Aggregate push down #10

Open legrandlegrand opened 7 years ago

legrandlegrand commented 7 years ago

Hello, Having this Foreign Data Wrapper is a very interesting thing ! I have just build and installed it, and cheched what was the SQL syntax sent to monetdb:

on postgres: CREATE FOREIGN TABLE person (id integer, name varchar(40)) SERVER monetdb_server ... ; SELECT count(*),name FROM person where id=1 group by name ;

on monetdb: call querylog_enable() ; select * from sys.querylog_history ;

gives the statement select * from person;

does that mean that there is no Filter nor Aggregate push down ?

Thanks in advance Regards PAscal

legrandlegrand commented 7 years ago

Latest postgres_fdw extension https://github.com/postgres/postgres/tree/master/contrib/postgres_fdw supports Filter and Aggregate pushdown (as many other features). But it is a quite big developpment ! May be one day somebody will merge postgres_fdw and monetdb_fdw, then I'm available for testing ;o)