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

Поиск
Список
Период
Сортировка
От Dave Dutcher
Тема Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
Дата
Msg-id 011e01c737f6$c449c580$8300a8c0@tridecap.com
обсуждение исходный текст
Ответ на Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)  (Rolf Østvik (HA/EXA) <rolf.ostvik@ericsson.com>)
Ответы Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)  (Rolf Østvik (HA/EXA) <rolf.ostvik@ericsson.com>)
Список pgsql-performance
Дерево обсуждения 
> -----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 по дате отправления:

Предыдущее
От: Rolf Østvik (HA/EXA)
Дата:
Сообщение: Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)