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

2009-07-28 Thread Ole Tange
The following bug has been logged online: Bug reference: 4949 Logged by: Ole Tange Email address: postgresql@tange.dk PostgreSQL version: 8.3.7 Operating system: Debian GNU/Linux Description:NOT IN is prohibitive slower than the rewrite for medium to large sets

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

2009-07-28 Thread Ole Tange
On Tue, Jul 28, 2009 at 3:47 PM, Tom Lane wrote: > "Ole Tange" 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 sim

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

2009-07-29 Thread Ole Tange
On Wed, Jul 29, 2009 at 12:16 AM, Tom Molesworth wrote: > Ole Tange wrote: >> On Tue, Jul 28, 2009 at 3:47 PM, Tom Lane wrote: >>> "Ole Tange" writes: >>> >>>> (modulo NULLs which seem to always cause problems in NOT INs). >>> >&