On Tue, Jan 17, 2017 at 4:26 AM, Rushabh Lathia <rushabh.lat...@gmail.com> 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
