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

Re: Strange behavior after upgrade from 9.0 to 9.2

From: Andrzej Zawadzki <zawadaa(at)wp(dot)pl>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Strange behavior after upgrade from 9.0 to 9.2
Date: 2012-10-08 16:14:25
Message-ID: 5072FBE1.6010700@wp.pl (view raw or flat)
Thread:
Lists: pgsql-performance
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


In response to

pgsql-performance by date

Next:From: Merlin MoncureDate: 2012-10-08 19:50:16
Subject: Re: Scaling 10 million records in PostgreSQL table
Previous:From: Tom LaneDate: 2012-10-08 15:56:27
Subject: Re: Strange behavior after upgrade from 9.0 to 9.2

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