Enzo Daddario <enzo@xxxxxxxxxxxxxxx> 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
