TechPlanetScalealmost 2 years ago
Optimizing aggregation in the Vitess query planner
4 min read
A Vitess bug caused VTGate to fetch excessive data and OOM errors on aggregation queries. The planner could not delegate aggregation to MySQL due to ordering blocking pushdown. Fixing the tree rewriting fixed-point to push aggregation through joins resolves the issue.
Level
Hype check
Tap to vote and see what everyone thinks.