Skip site navigation (1) Skip section navigation (2)

Re: zero performance on query

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: (view raw, whole thread or download thread mbox)
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 */

In response to

pgsql-performance by date

Next:From: Merlin MoncureDate: 2005-10-26 12:05:21
Subject: Re: zero performance on query
Previous:From: Rich DoughtyDate: 2005-10-26 08:33:48
Subject: Re: Outer join query plans and performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group