On Tue, Jan 17, 2017 at 4:26 AM, Rushabh Lathia <[email protected]> wrote: > Another observation is, HashAggregate (case 1) is performs better compare to > GroupAggregate (case 2), but still it doesn't justify the cost difference of > those two.
It may not be the only issue, or even the main issue, but I'm fairly suspicious of the fact that cost_sort() doesn't distinguish between the comparison cost of text and int4, for example. -- Peter Geoghegan -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
