| 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: | Whole Thread | Raw Message | 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
******************************************************************************
| 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 |