Re: Strange behavior after upgrade from 9.0 to 9.2 - Mailing list pgsql-performance

Andrzej Zawadzki <zawadaa@wp.pl> writes:
> On 08.10.2012 16:52, Tom Lane wrote:
>> [ counts... ]  You've got nine base relations in that query.  I think
>> you need to increase from_collapse_limit and/or join_collapse_limit.

> Bingo! Thank you!

> But... looks like in 9.0 this worked differently or option was skipped?
> Because I had default settings of that options and query has worked fine.

It looks like 9.0 wasn't flattening the EXISTS subqueries, so those
tables didn't count as relations of the main query.

            regards, tom lane