Optimising #PostgreSQL Aggregates: What Can an Extension Do? https://www.pgedge.com/blog/optimising-postgresql-aggregates-what-can-an-extension-do
www.pgedge.comOptimising PostgreSQL Aggregates: What Can an Extension Do?Generated SQL is full of redundant sorts no one can edit out. PostgreSQL 19 lets an extension strip them at plan time: a 10M-row sum drops from 5.7s to 3.7s. By Andrei Lepikhov.