| From: | "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: zero performance on query |
| Date: | 2005-10-26 10:30:51 |
| Message-ID: | 20051026103051.GB1742@uio.no |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Oct 25, 2005 at 10:26:43PM -0600, Sidar López Cruz wrote:
> 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)
Now, this is interesting; it seems to trigger exactly the same oddity as my
query did (at least one of them; the materialized sequential scan).
/* Steinar */
--
Homepage: http://www.sesse.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2005-10-26 12:05:21 | Re: zero performance on query |
| Previous Message | Rich Doughty | 2005-10-26 08:33:48 | Re: Outer join query plans and performance |