Postgres Pro
Downloads
Home   >   mailing lists

Re: Very slow DELETE on 4000 rows of 55000 row table - Mailing list pgsql-sql

From Tom Lane
Subject Re: Very slow DELETE on 4000 rows of 55000 row table
Date
Msg-id 21308.1175583840@sss.pgh.pa.us
Whole thread Raw
In response to Very slow DELETE on 4000 rows of 55000 row table  (Bryce Nesbitt <bryce1@obviously.com>)
Responses Re: Very slow DELETE on 4000 rows of 55000 row table  (Bryce Nesbitt <bryce1@obviously.com>)
List pgsql-sql
Tree view 
Bryce Nesbitt <bryce1@obviously.com> writes:
> I've got a DELETE FROM that seems to run forever, pegging the CPU at
> 100%.  I can't figure out why it's slow.  Any clues?

Unindexed foreign key constraints pointing to this table, perhaps?
EXPLAIN ANALYZE would give a great deal more clue than plain EXPLAIN.
        regards, tom lane

pgsql-sql by date:

Previous
From: Bryce Nesbitt
Date:
Subject: Very slow DELETE on 4000 rows of 55000 row table
Next
From: "Shavonne Marietta Wijesinghe"
Date:
Subject: Re: Update problem.