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

From Andrzej Zawadzki
Subject Re: Strange behavior after upgrade from 9.0 to 9.2
Date
Msg-id 5072F41D.5010202@wp.pl
Whole thread Raw
In response to Re: Strange behavior after upgrade from 9.0 to 9.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Strange behavior after upgrade from 9.0 to 9.2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On 08.10.2012 16:52, Tom Lane wrote:
> Andrzej Zawadzki <zawadaa@wp.pl> writes:
>> I have no idea whats wrong. Looks like planer bad decision.
> [ 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.

--
Andrzej Zawadzki


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange behavior after upgrade from 9.0 to 9.2
Next
From: Tom Lane
Date:
Subject: Re: Strange behavior after upgrade from 9.0 to 9.2