Performance in subconsult

From: Sonia Sanchez Diaz <sonny(at)piaget(dot)dgsca(dot)unam(dot)mx>
To: pgsql-general(at)postgresql(dot)org
Subject: Performance in subconsult
Date: 2002-03-26 19:14:35
Message-ID: Pine.SGI.4.10.10203261106590.83992-100000@piaget.dgsca.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello there!

I have the next query:

psql# select * from table1 t1 where not exists (select * from table2 t2
where t2.id = t1.id);

The execution of this uses more than 90% of my CPU performance and the
answer is slow...

Is there any wrong on my query?

Thanks for the posible answers.

******************************************************************************
Direccion General de Servicios de Computo Academico
Productos Interactivos
Sonia Sanchez Diaz
e-mail: sonny(at)piaget(dot)dgsca(dot)unam(dot)mx
tel: (5)6-22-81-13
ICQ: 127002683
******************************************************************************

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2002-03-26 19:20:08 Re: Altering a CHAR(4) column CHAR(5) changing pg_attribute
Previous Message PG Explorer 2002-03-26 19:05:18 Re: ISOLATION LEVEL SERIALIZABLE