Re: DELETE SQL too slow.

Diogo Biazus  writes:
> I'm having problems with delete commands in postgres. They are too slow.
> I'm trying to delete a set o 300 rows in table with 50000 rows with a 
> simple command like:

> DELETE FROM table WHERE field1 = '4'

> When I run the explain it tells me that index_scan is being used. But to 
> complete the delete it takes more than 30 minutes and the CPU use never 
> rise above 10%.

I'm betting this table is referenced by foreign key constraints on other
tables, and you are missing some needed indexes on those other tables.

			regards, tom lane