Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)

["Dave Dutcher" <dave(at)tridecap(dot)com>]

> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org 
> [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of 
> Rolf Østvik (HA/EXA)

Have you tried "set enable_sort=off" with 8.1.2?  I'm not sure if that will
change anything because it has to do at least one sort.  Its just a lots
faster to do a hashagg + small sort than one big sort in this case.  (I
wonder if there should be enable_groupagg?)