Enzo Daddario <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
