Re: Overhauling GUCS

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: Overhauling GUCS
Дата
Msg-id 484ECA4C.20004@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: Overhauling GUCS  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Gregory Stark wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
>> ...default_statistics_target?"..."Uhh 10." 
> 
> Ah, but we only ever hear about the cases where it's wrong of course. In other
> words even if we raised it to some optimal value we would still have precisely
> the same experience of seeing only posts on list about it being insufficient.

Yet if it was raised above the optimal, wouldn't you expect to hear cases
where it was too high?

It seems a slow painful way of finding a good setting might be to
keep increasing it until we had cases where the lists start telling
people they need to lower the parameter?




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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics
Следующее
От: "Nathan Boley"
Дата:
Сообщение: Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics