-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I guess this may have come up before, but now that 7.4 has the IN with
improved performance, it may be time to revisit this topic.
Compare these two algorithms (in plpgsql):
(a)
DELETE FROM foo WHERE ctid IN (
SELECT foo.ctid
FROM ..
Tom,
I understand the problem and your solution makes sense although I am
still puzzled by the machine under-utilization. If you run the original
query and monitor the IO/CPU usage you find that it is minimal.
here is the output from iostat 1 for a brief portion of the query. I am
very curi
