Thomas Kellerer <spam_eater@xxxxxxx> writes: > Tom Lane, 24.07.2012 16:23: >> IIRC, type tid doesn't have any hash support. > So the "bad" plan is expected? Joins on tid columns just aren't supported very well at the moment. Partly that's from lack of round tuits, and partly it's because it doesn't seem all that wise to encourage people to use them. There are gotchas if any of the rows receive concurrent updates. FWIW, it might be helpful to cast this as a NOT EXISTS rather than NOT IN subquery. 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
