Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: SELECT Aggregate
- From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
- To: Phillip Smith <phillips(at)weatherbeeta(dot)com(dot)au>, pgsql-sql(at)postgresql(dot)org
- Subject: Re: SELECT Aggregate
- Date: Thu, 29 Jun 2006 17:51:11 -0700 (PDT)
> I've tried Aaron's suggestion of the GROUP BY and I don't know much about > it, but it ran for around 17 hours and still going (it had a dedicated Dual > Xeon 3.0GHz box under RHEL4 running it!) Maybe, this query that you are trying to run is a good candidate for a "Materialize View". http://archives.postgresql.org/pgsql-performance/2004-02/msg00279.php Also before you run your query you might want to see the explain plan is. Perhap it is using a sequencial scan in a place where an index can improve query preformance.
- Follow-Ups:
- Re: SELECT Aggregate
- From: Phillip Smith
- Re: SELECT Aggregate
- References:
- Re: SELECT Aggregate
- From: Phillip Smith
- Re: SELECT Aggregate
- Prev by Date: Re: SELECT Aggregate
- Next by Date: Re: SELECT Aggregate
- Previous by thread: Re: SELECT Aggregate
- Next by thread: Re: SELECT Aggregate
- Indexes: