| From: | "Rhys Stewart" <rhys(dot)stewart(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | JUST NOT ADDING UP |
| Date: | 2006-06-23 13:43:53 |
| Message-ID: | 189966030606230643n2d85128foc8f53cc895f13fa8@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
hi all,
something is not adding up. the following query is taking a long time
to run.(its still running right now)
select distinct on (prem) prem, num, addy, mynum,myad,ff.address, matchtype,
the_geom
from daily.recheck2, _sp_myparcels ff
where
prem not in (
select distinct on (prem) prem from daily.recheck2 dr, _sp_myparcels ff
where ff.address = unabrev
)
AND btrim(addy) = btrim(myad)
AND num = mynum
UNION
select distinct on (prem) prem, num, addy, mynum,myad,dr.unabrev,
matchtype, ff.the_geom
from daily.recheck2 dr, _sp_myparcels ff--, feeder_polygon
where ff.address = unabrev
the thing is if i run the first query by itself, it takes like about 2
seconds, and if i run the subquery that takes about 2 seconds also, so
why (well its now finished, took all of 3.31 minutes) does it take so
long?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2006-06-23 13:49:19 | Re: Plperl and my() lexical variables bug? |
| Previous Message | Kenneth Downs | 2006-06-23 11:30:22 | Re: minimizing downtime when upgrading |