Hey everybody, I'm having an issue executing the query I want. I've
let a couple queries run a good 20 minutes and it still hasn't
finished. For my app, this is way too long to be useful, and I'm not
real sure what else I can do, let alone if my query is even what I
So I'm really hoping the great internets will help me out.
example rows from huge table (almost 900,000 rows):
fips, pollutant, value
1, co, 0.1
1, co, 0.2
1, co, 0.3
1, so, 1.0
1, so, 2.0
2, co, 0.5
2, co, 0.3
example from small table (3233 rows)
fips, geom, name
1, some geometry, "Some County, Some State"
2, some geometry, "Some Other County, Some State"
Every fips in the small table has MULTIPLE rows in the huge table
(roughly 300 per).
So, what I need is all kinds of things, but to start (pseudo-query):
SELECT small.fips, small.geom, small.name, SUM(huge.value) from small
JOIN huge on huge.fips = small.fips WHERE (SUM(huge.value)) > 500 AND
wonder if that makes sense. Obviously, can't have an aggregate in
where clause, so I've tried a couple WHERE (SELECT) kind of things,
nothing working out too well.
So first, if anyone has any idea on the best way I can do a WHERE
(sum(huge.value) > 500)
any ideas on how I could speed up the query, I would be so extremely
Thanks in advance!
P.S. Sorry, the cake was a lie.
pgsql-general by date
|Next:||From: Francisco Reyes||Date: 2008-05-28 19:42:47|
|Subject: Re: Psql crashes with Segmentation fault on copy from|
|Previous:||From: Gregory Stark||Date: 2008-05-28 19:18:51|
|Subject: Re: Bottom Posting|