build1 publisher
A CAST in the GROUP BY key turns 440 buffer reads into 8,971 in PostgreSQL 17
Aleksander Frolov loaded a million orders into MySQL 8.4.11 and PostgreSQL 17.11 and found the aggregating view 13 times slower on Postgres, even though the planner pushed both predicates below the grouping.
Publishers:dev.to
Reality
- Evidence68
- Adoption
- Insufficient
- Hype gap+12
- Incentives30
- Confidence62