Thomas Kellerer <spam_eater@xxxxxxx> writes: > Tom Lane wrote on 24.07.2012 17:55: >> FWIW, it might be helpful to cast this as a NOT EXISTS rather than >> NOT IN subquery. > Hmm. How would you change that into an NOT EXISTS clause (so that one of the duplicates remains) > Everything I come up with is in fact slower than the NOT IN solution. Well, it would only help if you're running a PG version that's new enough to recognize the NOT EXISTS as an anti-join; and even then, it's possible that joining on a tid column forecloses enough plan types that you don't get any real benefit. But I'm just guessing. Can you show exactly what you tried and what EXPLAIN ANALYZE results you got? regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
