cwida / duckpgq-extension

DuckDB extension that adds support for SQL/PGQ
https://duckpgq.notion.site/b8ac652667964f958bfada1c3e53f1bb?v=3b47a8d44bdf4e0c8b503bf23f1b76f2
MIT License
86 stars 7 forks source link

Improve performance on any directed edges #110

Closed Dtenwolde closed 8 months ago

Dtenwolde commented 8 months ago

Fixes #107 Fixes #109 Fixes #60

A bottleneck was the edge patterns containing the ANY edge (-[]-), see IS3. Previously this resulted in a slow blockwise nested loop join. We transform it into a union on the edge table (src, dst, * from edge_table UNION ALL dst, src, * from edge_table), resulting in two hash joins.