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
pgsql-performance by date
|Next:||From: Alex Turner||Date: 2005-03-22 14:56:02|
|Subject: Planner issue|
|Previous:||From: Kenneth Marshall||Date: 2005-03-22 14:00:50|
|Subject: Re: What about utility to calculate planner cost constants?|
pgsql-admin by date
|Next:||From: KÖPFERL Robert||Date: 2005-03-22 15:48:00|
|Subject: Databases there, tables away|
|Previous:||From: Dragan Matic||Date: 2005-03-22 13:56:56|
|Subject: Re: Fixing "old version was found" error|