No filter nor Aggregate push down

[legrandlegrand]

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]

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)