Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?) - Mailing list pgsql-performance

From Dave Dutcher
Subject Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
Date
Msg-id 011e01c737f6$c449c580$8300a8c0@tridecap.com
Whole thread Raw
In response to Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)  (Rolf Østvik (HA/EXA) <rolf.ostvik@ericsson.com>)
Responses Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
List pgsql-performance
Tree view 
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.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?)

pgsql-performance by date:

Previous
From: Rolf Østvik (HA/EXA)
Date:
Subject: Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
Next
From: Dave Cramer
Date:
Subject: Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)