Re: Speeding up DELETEs on table with FKs ...

"Marc G. Fournier"  writes:
> I posted to -sql the other day about an atrociously slow DELETE on a table 
> that has two FKs to a 'parent' table ... if the # of records in the table 
> that match the condition is 1, its fast ... in the sample I'm working 
> with, there are 1639 records in the table ...

"parent" table?  A DELETE doesn't check FKs in the table it's deleting.
What it checks are FKs in other tables that reference items in the
deletion table.  You sure you are worrying about the right set of FKs?
		regards, tom lane