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

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why does adding SUM and GROUP BY destroy performance?
Date: 2003-09-18 10:09:14
Message-ID: 1063879753.11739.1583.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)l(dot)johnson(at)cox(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2003-09-18 10:25:17 Re: varchar vs. text
Previous Message Ron Johnson 2003-09-18 10:04:36 Re: High-volume shop uses PostgreSQL