Jeff Boes wrote:
> Why would a delete involving a subselect run so much longer than the
> individual delete commands?
Some SQL statements are faster than others. Try to rewrite your query to
use EXISTS instead of IN and see if it makes any difference. I would
recommend using EXPLAIN to find out what PostgreSQL is really doing and
optimize from there.
jochem
