2006/12/6, Markus Schiltknecht <[EMAIL PROTECTED]>:
Hi,
Tomi N/A wrote:
>> > When the subselect returns a lot of results, pgsql really takes it's
>> time.
>
> 8.1.something
PostgreSQL 8.2 improved a lot for IN clauses with lots of values. I
think it now performs as good as an equal join query.
Thats good to know. I'm looking forward to taking it for a spin...as
soon as I make sure my data is safe.
t.n.a.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/