Quick Links

delete query taking way too long

From:	Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To:	pgsql-general(at)postgresql(dot)org
Subject:	delete query taking way too long
Date:	2010-08-12 11:14:03
Message-ID:	20100812131403.4af8646d@dawn.webthatworks.it
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

I've
delete from catalog_items where ItemID in (select id from
import.Articoli_delete);

id and ItemID have an index.

catalog_items is ~1M rows
Articoli_delete is less than 2K rows.

This query has been running for roughly 50min.
Right now it is the only query running.

PostgreSQL 8.3.4 on x86_64-pc-linux-gnu, compiled by GCC cc (GCC)
4.1.2 20061115 (prerelease) (Debian 4.1.1-21)

	From	Date	Subject
Next Message	Glyn Astill	2010-08-12 11:31:03	Re: delete query taking way too long
Previous Message	Leif Biberg Kristensen	2010-08-12 11:08:56	Re: MySQL versus Postgres