Normally in postgresql "in" syntax is slower than "join", in particular if the returning dataset gets a bit big. There are other factors such as proper use of indexes, vacuum analyze. I think the performance difference is now smaller on 7.4.x of postgresql.
Deleting would normally not happen everytime, so I guess the performance aspect is not much of an issue.
General developer forum
SQL help
This discussion has been locked so you can no longer reply to it.