4 ms·
This is definitely something I intend to fix. My initial intent was to use duckdb for fast vectored query execution but I wasn't able to create a planner / exe
by wanderinglight 2y ago
This is definitely something I intend to fix.
My initial intent was to use duckdb for fast vectored query execution but I wasn't able to create a planner / execution hook that uses duckdb internally.
Will definitely checkout pg_analytics / Datafusion to see if the same can be integrated here as well.
Thanks for the pointers.
- mildbyte 2y agoHave you seen duckdb_fdw (https://github.com/alitrack/duckdb_fdw https://github.com/alitrack/duckdb_fdw)? IIRC it's built based on sqlite_fdw, but points the outbound queries to DuckDB instead of SQLite, and it does handle running aggregations inside of DuckDB. Could be useful.
- wanderinglight 2y agoThis is great, thank so much! I'll see if I can I can integrate this and how it compares to parquet_fdw.