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
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
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).
>>>
>&