Edmund Dengler <edmundd@xxxxxxxxxxxx> writes: > This table has 3 foreign keys, but that should not matter during deletes. Richard was inquiring about foreign keys linking *into* this table, not out of it. In particular, foreign keys that don't have indexes on the referencing columns; those will incur seqscans to check for appearances of the value you are deleting. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)