On 08.10.2012 17:56, Tom Lane wrote:
> Andrzej Zawadzki <zawadaa(at)wp(dot)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.
Thanks for explanation.
Looks like now I can switch to 9.2.1 on production server. :-)
--
Andrzej Zawadzki