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

--- 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