Optimising #PostgreSQL Aggregates: What Can an Extension Do?
www.pgedge.com
Optimising 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.
0 Replies
0 Reposts