Re: BUG #4949: NOT IN is prohibitive slower than the rewrite for medium to large sets

"Ole Tange" <postgresql.org@tange.dk> writes:
> (modulo NULLs which seem to always cause problems in NOT INs).

> Because it can be rewritten, NOT IN should never be much slower than the
> rewritten solution, as PostgreSQL should simply rewrite NOT IN to the
> above.

Let's see, you understand that the rewrite violates the SQL standard
semantics of NOT IN, but you think we should do it anyway?

            regards, tom lane