Noel <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au> writes:
> I'm trying to delete from a table which has 42Mill rows, using a foreign
> key, which is index.
> The delete has been going three days now :( and is really frustrating.
It sounds like you're getting a really bad plan for the queries
triggered by the foreign key constraints. One thing to make sure
of is that the datatype of the referenced and referencing columns
are the same in each foreign key relationship. Also check that the
planner statistics are reasonably up to date (pg_class.relpages and
pg_class.reltuples should be in the vicinity of reality, at least).
regards, tom lane