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.
