"Bharat Patel" <[EMAIL PROTECTED]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
