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. :-)
In response to
pgsql-performance by date
|Next:||From: Merlin Moncure||Date: 2012-10-08 19:50:16|
|Subject: Re: Scaling 10 million records in PostgreSQL table|
|Previous:||From: Tom Lane||Date: 2012-10-08 15:56:27|
|Subject: Re: Strange behavior after upgrade from 9.0 to 9.2|