How we made WINDOW JOIN parallel and vectorized

WINDOW JOIN is QuestDB's dedicated syntax for aggregating one table over a time window around each row of another. We parallelized it across page frames, used a low-cardinality join key to unlock a vectorized aggregation path, and benchmarked it against Timescale, DuckDB, and ClickHouse on a 50M x 150M row workload.
26 points by tosh 118 days ago questdb.com 2 comments
Summary not yet generated for this article.

Comments (2 of ) ⌛

Loading more comments... ⌛
Scroll down to load more comments
No comments available.
Type to search HN and engineering blog articles
Press Escape to close  |  ↑↓ to navigate  |  Enter to open