Can GROUP BY still be optimized after all these years? Link: https://pivotlake.io/blog/know-your-limit-faster-top-k-aggregation/ Discussion: https://news.ycombinator.com/item?id=50354097