Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
eliminating records not in (select id ... so SLOW?
- From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
- To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
- Subject: eliminating records not in (select id ... so SLOW?
- Date: Thu, 31 Jul 2008 23:45:30 +0200
- Message-id: <20080731234530.32f0f62e@dawn.webthatworks.it> <text/plain>
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
- Follow-Ups:
- Re: eliminating records not in (select id ... so SLOW?
- From: Tom Lane
- Re: eliminating records not in (select id ... so SLOW?
- From: Lennin Caro
- Re: eliminating records not in (select id ... so SLOW?
- Prev by Date: Re: Using PostGres general distribution
- Next by Date: Re: eliminating records not in (select id ... so SLOW?
- Previous by thread: CAST(integer_field AS character) truncates trailing zeros
- Next by thread: Re: eliminating records not in (select id ... so SLOW?
- Indexes: