"Bharat Patel" <bharatpatelk(at)gmail(dot)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