PG version? Maybe worth to try NOT EXISTS instead of NOT IN
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sabio - PSQL Sent: Tuesday, March 22, 2005 7:23 AM To: PostgreSQL Admin Subject: [ADMIN] Too slow How can I improve speed on my queries. For example this query takes one day executing itself and it has not finalized !!! "create table tmp_partes as select * from partes where identificacion not in (select cedula from sujetos)" partes have 1888000 rows, an index on identificacion sujetos have 5500000 rows, an index on cedula ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
