From: | Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz> |
---|---|
To: | Nathan Barnett <nbarnett(at)cellularphones(dot)com> |
Cc: | "'Stephan Szabo'" <sszabo(at)kick(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Statistical Analysis |
Date: | 2000-07-24 20:51:16 |
Message-ID: | 397CAC44.6934EA0E@catalyst.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Nathan Barnett wrote:
>
> Stephan,
> The SORT is what I'm trying to avoid because I was using a group by to grab
> all the data in the groups that I needed, but it requires a sort to group by
> and this bottlenecked the query. I really just wanted to grab a sample of
> all the rows in the table and then perform the group by on the subset to
> avoid the overhead of sorting the whole table. My query has no where
> clauses and thus must sort through all of the data being analyzed. It then
> aggregates the data in a table that is then being used in the realtime
> queries. The analysis must be able to run every hour.
What about using random() in the WHERE clause?
Regards,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267
From | Date | Subject | |
---|---|---|---|
Next Message | Nathan Barnett | 2000-07-24 20:52:52 | RE: Statistical Analysis |
Previous Message | Nathan Barnett | 2000-07-24 20:45:07 | RE: Statistical Analysis |