Re: Strange behavior after upgrade from 9.0 to 9.2

Поиск
Список
Период
Сортировка
От Andrzej Zawadzki
Тема Re: Strange behavior after upgrade from 9.0 to 9.2
Дата
Msg-id 5072F41D.5010202@wp.pl
обсуждение исходный текст
Ответ на Re: Strange behavior after upgrade from 9.0 to 9.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Strange behavior after upgrade from 9.0 to 9.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Strange behavior after upgrade from 9.0 to 9.2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Strange behavior after upgrade from 9.0 to 9.2