Enzo Daddario <enzo@pienetworks.com> writes:
> I am now required the remove thousands of obsolete records from table
> "X" and even though I have removed all related rows in all related
> tables, the deletion of rows in table "X" is taking WAY TOO LONG.
You need to put indexes on the referencing columns. Then start a fresh
session for doing the actual deletes (FK check plans are usually cached
per-session).
regards, tom lane
