Pivot Lake Blog company blog
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.
- Points
- 113
- HN comments
- 21
- Submissions
- 1
- Cited by
- 0 commenters
Databases & DataSystems & Performance2026
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| Nov 3, 2026 | Can GROUP BY still be optimized after all these years? by ntur1337 | 113 | 21 |
