Bryce Nesbitt <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly