Re: Revisiting default_statistics_target

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Revisiting default_statistics_target
Дата
Msg-id 53552.137.122.68.138.1243018255.squirrel@dunslane.net
обсуждение исходный текст
Ответ на Re: Revisiting default_statistics_target  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Fri, May 22, 2009 2:41 pm, Tom Lane wrote:
> "Greg Sabino Mullane" <greg@turnstep.com> writes:
>> No, the 10 to 100 was supported by years of people working in the
>> field who routinely did that adjustment (and >100) and saw great
>> gains. Also, as the one who originally started the push to 100, my
>> original goal was to get it over the "magic 99" bump, at which the
>> planner started acting very differently.
>
> That particular issue is gone anyway.
>
> I'm not in a big hurry to revert this change either, but I think
> Jignesh's results are sufficient reason to take a closer look at
> the decision.
>


We also need more data points just about this test. Does the behaviour
hold for other platforms, and what is the relationship between stats
target and timings (is it linear or is there a sudden jump at some level)?

cheers

andrew



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Revisiting default_statistics_target
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Revisiting default_statistics_target