It's the memory latency, stupid
Summary
Maor Kern argues memory latency is the primary bottleneck in GROUP BY queries and demonstrates how cache-aware CPU work can accelerate aggregations. The post walks through benchmarks with perf counters, explains a two-phase radix partitioning approach to improve cache locality, and shows substantial single-core speedups with further gains when parallelized.