When to break large delete queries up?
from experience i can say that one large delete is usually better. however, there can be some corner cases with IN, which might invalidate my statement but basically this is true.
Make sure your got enough work_mem around to allow PostgreSQL to nicely hash the IN.