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

Historical memory prices 1960-2026
vga1 · Hacker News · 21h ago
TOP500 at ISC’26: We have a New Number 1 Supercomputer
rbanffy · Hacker News · 20h ago
DSpark: Speculative decoding accelerates LLM inference [pdf]
aurenvale · Hacker News · 2d ago
Anthropic says Alibaba illicitly extracted Claude AI model capabilities
htrp · Hacker News · 4d ago
Why did this journal retract two 1940s papers by Max Planck?
DR_MING · Hacker News · 6h ago