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

From: "Dave Dutcher" <dave(at)tridecap(dot)com>
To: 'Rolf Østvik (HA/EXA)' <rolf(dot)ostvik(at)ericsson(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
Date: 2007-01-14 16:12:18
Message-ID: 011e01c737f6$c449c580$8300a8c0@tridecap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> -----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?)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Cramer 2007-01-14 16:52:52 Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
Previous Message Rolf Østvik (HA/EXA) 2007-01-14 15:34:03 Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)