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

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 (view raw or flat)
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

pgsql-performance by date

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

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