Re: Why does adding SUM and GROUP BY destroy performance?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Why does adding SUM and GROUP BY destroy performance?
Дата
Msg-id 1063879753.11739.1583.camel@haggis
обсуждение исходный текст
Ответ на Why does adding SUM and GROUP BY destroy performance?  (David Link <dvlink@yahoo.com>)
Список pgsql-general
On Wed, 2003-09-17 at 12:51, David Link wrote:
> Hi,
>
> Why does adding SUM and GROUP BY destroy performance?
> details follow.
> Thanks, David Link

PostgreSQL's generalized UDFs makes optimizing for the standard
aggregates very hard to do.  There should be some improvement in
v7.4, though.

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

"Those who would give up essential Liberty to purchase a little
temporary safety, deserve neither Liberty nor safety." or
something like that
Ben Franklin, maybe


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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: High-volume shop uses PostgreSQL
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: varchar vs. text