Re: Deleting row in 7.4 takes for ever

"Bharat Patel" <bharatpatelk@gmail.com> writes:
> I have a table that has 5.4 million rows of data in it.  4.6 million of
> these rows are just administrative messages and not necessary so I'd like to
> delete them.  If I try and delete them, it takes 69 minutes to delete ~650K
> rows.

I'm betting on an unindexed foreign-key constraint linking to this
table.

            regards, tom lane