PG version = 8.0 over Linux Fedora Core 3 PostgreSQL was compiled from source
Lee Wu wrote:
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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
