1
It's the memory latency, stupid
When your database CPU is at 100%, what is it actually doing? Memory stalls, CPU caches, and how radix partitioning makes GROUP BY faster.
Pivot Lake Blog
Pivot brings the speed and concurrency the AI era demands to the lakehouse. Run low-latency, high-concurrency queries on a single architecture that unifies real-time analytics and lakehouse workloads.
- Popular posts
- 2
- Total points
- 384
- HN comments
- 119
- Rank
- #3,505 company
Visit pivotlake.io → On Hacker News Oct 2026 – Nov 2026
Systems & Performance 2Hardware & Electronics 1Databases & Data 1
2
Can GROUP BY still be optimized after all these years?
An optimization that made Pivot significantly faster on GROUP BY queries with a Top-K operator above them, and a walkthrough of how analytical databases run GROUP BY in the first place.