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

Spaghettifying DRAM
matt_d · Hacker News · 5h ago
DeepSeek V4 Pro 0813
explosion-s · Hacker News · 1d ago
Heart aerospace completes first flight of largest electric aircraft
chha · Hacker News · 5h ago
Nine PBS could lose 70 years of archives after cloud vendor goes defunct
vinayakborkar · Hacker News · 6h ago
Tracking down the 16-year-old WAL-reset SQLite bug
ropbear · Hacker News · 1d ago