Re: hash semi join caused by "IN (select ...)"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Clemens Eisserer <linuxhippy(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: hash semi join caused by "IN (select ...)"
Date: 2011-05-16 23:22:48
Message-ID: 23922.1305588168@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Clemens Eisserer <linuxhippy(at)gmail(dot)com> writes:
> I have a quite complex, performance sensitive query in a system with a
> few (7) joins:
> select .... from t1 left join t2 .... WHERE id IN (select ....)

Does it work as expected with one less join? If so, try increasing
join_collapse_limit ...

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Johansen 2011-05-17 02:44:20 Re: hash semi join caused by "IN (select ...)"
Previous Message Clemens Eisserer 2011-05-16 22:30:22 hash semi join caused by "IN (select ...)"