Re: BUG #4264: Optimizer fails to use hash_aggregate when appropriate.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #4264: Optimizer fails to use hash_aggregate when appropriate.
Дата
Msg-id 23377.1214427355@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #4264: Optimizer fails to use hash_aggregate when appropriate.  ("Scott Carey" <scott@richrelevance.com>)
Ответы Re: BUG #4264: Optimizer fails to use hash_aggregate when appropriate.
Список pgsql-bugs
Дерево обсуждения 
"Scott Carey" <scott@richrelevance.com> writes:
> The query optimizer fails to use a hash aggregate most of the time.  This is
> an inconsistent behavior.

Hash aggregation is not used when a DISTINCT aggregate is specified.
DISTINCT forces a sort, so there wouldn't be any advantage.

> Of course DB hints would solve this.

No, they wouldn't.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Scott Carey"
Дата:
Сообщение: BUG #4264: Optimizer fails to use hash_aggregate when appropriate.
Следующее
От: "Clemens Fischer"
Дата:
Сообщение: BUG #4265: PostgreSQL fails to compile