Re: transparent use of pre-aggregated value for very large datasets - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: transparent use of pre-aggregated value for very large datasets
Date
Msg-id 20030303012615.GA3358@wolff.to
Whole thread Raw
In response to transparent use of pre-aggregated value for very large datasets  (chaudhar@umich.edu (shahbaz))
List pgsql-general
On Fri, Feb 28, 2003 at 17:36:33 -0800,
  shahbaz <chaudhar@umich.edu> wrote:
>
> Any pointers?  Or preferably, any hackers will to take this on?  Or,
> even better, does this already exist and I just don't know about it
> :)?

If the number of groups isn't too large, the hash aggregate system in 7.4
might speed up your query enough. By using hashes, the sort step is
avoided which will speed things up for large tables.

7.4 won't be out for a while, but the feature is already in CVS so you
can see if it will help with your problem now.

pgsql-general by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Postgresql performace question
Next
From: Tom Lane
Date:
Subject: Re: difference between overlap and intersect using geometric types of postgresql