Joe Conway <mail(at)joeconway(dot)com> writes:
> I wonder if "[NOT] IN (subselect)" could be improved with a hash table in
> similar fashion to the hash aggregate solution Tom recently implemented?
It's being worked on ;-)
Assuming I get this done, the conventional wisdom that "EXISTS
outperforms IN" will be stood on its head --- unless we add planner code
to try to reverse-engineer an IN from an EXISTS, which is something I'm
not really eager to expend code and cycles on.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Bruce Momjian||Date: 2002-12-19 22:52:24|
|Subject: Re: EXISTS vs IN vs OUTER JOINS|
|Previous:||From: Ron Johnson||Date: 2002-12-19 19:36:36|
|Subject: Re: 4G row table?|