Skip site navigation (1) Skip section navigation (2)

not in(subselect) in 8.4

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: not in(subselect) in 8.4
Date: 2009-02-20 09:56:05
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
Just as a question to Tom and team,
I saw a post a bit ago, about plans for 8.4, and Tom said it is very
likely that 8.4 will rewrite subselects into left joins, is it still
in plans?

I mean query like:
select id from foo where id not in ( select id from bar);

select from foo f left join bar b on where is null;

the latter is most often much much faster on 8.1-8.3;




pgsql-performance by date

Next:From: marcin mankDate: 2009-02-20 11:14:44
Subject: Re: not in(subselect) in 8.4
Previous:From: PFCDate: 2009-02-19 13:09:04
Subject: Re: TCP network cost

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group