How we made WINDOW JOIN parallel and vectorized

·Hacker News··

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.

Read full article →

Related Articles

ASML says it sold 'absolutely nothing' in Europe in 2026
MC995 · Hacker News · 2d ago
"As a Language Model": Chat Template Switches LLM Self-Referential Voice
yu3zhou4 · Hacker News · 13h ago
Revealing the details of how OpenAI agents hacked Hugging Face
specked-citrus · Hacker News · 2d ago
Dutch governments builds alternative for Microsoft based on NixOS
fjfaase · Hacker News · 2d ago
Toyota is taking the Corolla electric
cisc · Hacker News · 4d ago