Re: [PERFORM] zero performance on query

2005-10-26 Thread Steinar H. Gunderson
On Wed, Oct 26, 2005 at 08:05:21AM -0400, Merlin Moncure wrote: > select count(*) from fotos f where not exists (select archivo from archivos a > where a.archivo = f.archivo) This was an optimization before 7.4, but probably isn't anymore. /* Steinar */ -- Homepage: http://www.sesse.net/

Re: [PERFORM] zero performance on query

2005-10-26 Thread Merlin Moncure
> 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 >

Re: [PERFORM] zero performance on query

2005-10-26 Thread Steinar H. Gunderson
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 wi

Re: [PERFORM] zero performance on query

2005-10-25 Thread Dmitri Bichko
1? Dmitri > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Sidar López Cruz > Sent: Wednesday, October 26, 2005 12:27 AM > To: pgsql-performance@postgresql.org > Subject: [PERFORM] zero performance on query > >

[PERFORM] zero performance on query

2005-10-25 Thread Sidar López Cruz
what happend with postgresql 8.1b4 performance on query? please help me !!! 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