Can GROUP BY still be optimized after all these years?

It's the memory latency, stupid

Why is Pivot fast?

Does ClickHouse really need its own storage format?