Re: eliminating records not in (select id ... so SLOW?

[Lennin Caro <lennin(dot)caro(at)yahoo(dot)com>]

--- On Thu, 7/31/08, Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> wrote:

> From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
> Subject: [GENERAL] eliminating records not in (select id ... so SLOW?
> To: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
> Date: Thursday, July 31, 2008, 9:45 PM
> I'm doing something like:
> 
> delete from table1 where id not in (select id from table2).
> 
> both id are indexed.
> 
> table1 contains ~1M record table2 contains ~ 600K record
> and id is
> unique.
> 
> The box is a 2x dual core Xeon (below 2GHz) with 4Gb ram.
> Default debian etch setup.
> 
> It has been working for over 2h now.
> 
> Is it normal?
> 
> -- 
> Ivan Sergio Borgonovo
> http://www.webthatworks.it
> 
you recently run vacuum ? 

> -- 
> Sent via pgsql-general mailing list
> (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general