What is the best strategy for deleting orphaned records from a large table.
The usual NOT IN is very slow so there must be a better way in postgres for dealing with these. I know it's best not to have the orphans in the first place but in this case it happened and I need to clean up before I can put in some referential integrity. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
