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

Too slow

From: Sabio - PSQL <slopez_pg(at)ceroriesgo(dot)co(dot)cr>
To: PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Too slow
Date: 2005-03-22 14:23:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-performance
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 TurnerDate: 2005-03-22 14:56:02
Subject: Planner issue
Previous:From: Kenneth MarshallDate: 2005-03-22 14:00:50
Subject: Re: What about utility to calculate planner cost constants?

pgsql-admin by date

Next:From: KÖPFERL RobertDate: 2005-03-22 15:48:00
Subject: Databases there, tables away
Previous:From: Dragan MaticDate: 2005-03-22 13:56:56
Subject: Re: Fixing "old version was found" error

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