From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
---|---|
To: | Sidar López Cruz <sidarlopez(at)hotmail(dot)com> |
Cc: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: zero performance on query |
Date: | 2005-10-26 12:05:21 |
Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB3417DD6AF@Herge.rcsinc.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
> look at this:
> select count(*) from fotos where archivo not in (select archivo from
> archivos)
> Aggregate (cost=4899037992.36..4899037992.37 rows=1 width=0)
> -> Seq Scan on fotos (cost=22598.78..4899037338.07 rows=261716 width=0)
> Filter: (NOT (subplan))
> SubPlan
> -> Materialize (cost=22598.78..39304.22 rows=805344 width=58)
> -> Seq Scan on archivos (cost=0.00..13141.44 rows=805344
> width=58)
>
> I WILL DIE WAITING FOR QUERY RESPONSE !!!
Try:
select count(*) from fotos f where not exists (select archivo from archivos a where a.archivo = f.archivo)
select count(*) from
(
select archivo from fotos
except
select archivo from archivos
);
From | Date | Subject | |
---|---|---|---|
Next Message | Steinar H. Gunderson | 2005-10-26 15:20:47 | Re: zero performance on query |
Previous Message | Steinar H. Gunderson | 2005-10-26 10:30:51 | Re: zero performance on query |