Skip site navigation (1) Skip section navigation (2)

Re: Too slow

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 (view raw or flat)
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

Responses

pgsql-admin by date

Next:From: Chris HooverDate: 2005-03-22 18:49:20
Subject: Re: Too slow
Previous:From: Tom LaneDate: 2005-03-22 18:37:32
Subject: Re: Databases there, tables away

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group