Re: Why does adding SUM and GROUP BY destroy performance? - Mailing list pgsql-general

From Ron Johnson
Subject Re: Why does adding SUM and GROUP BY destroy performance?
Date
Msg-id 1063879753.11739.1583.camel@haggis
Whole thread Raw
In response to Why does adding SUM and GROUP BY destroy performance?  (David Link <dvlink@yahoo.com>)
List 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 by date:

Previous
From: Ron Johnson
Date:
Subject: Re: High-volume shop uses PostgreSQL
Next
From: Ron Johnson
Date:
Subject: Re: varchar vs. text