search

alitrack / duckdb_fdw

DuckDB Foreign Data Wrapper for PostgreSQL
MIT License
272 stars 18 forks source link

array_agg is performed by PostgreSQL not by duckdb #20

Closed ahuarte47 closed 7 months ago

ahuarte47 commented 9 months ago

Hi, first of all, thank you very much for developing this amazing tool!

I am facing one issue executing a query that includes the array_agg function.

Without "array_agg" query plan looks great: image image

But when I add array_agg function, it is not included in the query to run in Duckdb, but it is perfomed by PostgreSQL: image image

The performance is very much worse, please, what I am doing wrong?, is there an issue? Thanks in advance

ahuarte47 commented 9 months ago

Maybe this filter of functions is the key?

ahuarte47 commented 8 months ago

I propose this PR that implements this issue

alitrack commented 7 months ago

sorry for the delay, and let me check it.

ahuarte47 commented 7 months ago

Thank you very much @alitrack for your review

ahuarte47 commented 7 months ago

I am closing this ticket, code got merged. Thanks @alitrack