What's the output of explain? --- On Thu, 12/8/10, Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> wrote: > From: Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> > Subject: delete query taking way too long > To: pgsql-general@xxxxxxxxxxxxxx > Date: Thursday, 12 August, 2010, 12:14 > 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 > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
