delete query taking way too long

Поиск
Список
Период
Сортировка
От Ivan Sergio Borgonovo
Тема delete query taking way too long
Дата
Msg-id 20100812131403.4af8646d@dawn.webthatworks.it
обсуждение исходный текст
Ответы Re: delete query taking way too long  (Glyn Astill <glynastill@yahoo.co.uk>)
Re: delete query taking way too long  (Jayadevan M <Jayadevan.Maymala@ibsplc.com>)
Re: delete query taking way too long  (Thom Brown <thom@linux.com>)
Re: delete query taking way too long  (tv@fuzzy.cz)
Список 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)

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


В списке pgsql-general по дате отправления:

Предыдущее
От: Leif Biberg Kristensen
Дата:
Сообщение: Re: MySQL versus Postgres
Следующее
От: Glyn Astill
Дата:
Сообщение: Re: delete query taking way too long