| From: | "Lee Wu" <Lwu(at)mxlogic(dot)com> |
|---|---|
| To: | "Sabio - PSQL" <slopez_pg(at)ceroriesgo(dot)co(dot)cr>, "PostgreSQL Admin" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Too slow |
| Date: | 2005-03-22 18:44:56 |
| Message-ID: | ECAB83AA52BCC043A0E24BBC00001024D2E6B7@mxhq-exch.corp.mxlogic.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
PG version?
Maybe worth to try NOT EXISTS instead of NOT IN
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Hoover | 2005-03-22 18:49:20 | Re: Too slow |
| Previous Message | Tom Lane | 2005-03-22 18:37:32 | Re: Databases there, tables away |