Re: Better default_statistics_target

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Better default_statistics_target
Дата
Msg-id 13872.1195016406@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Better default_statistics_target  (Greg Sabino Mullane <greg@turnstep.com>)
Ответы Re: Better default_statistics_target  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-patches
Greg Sabino Mullane <greg@turnstep.com> writes:
> Per a recent bug in which the planner can behave very differently at <
> 100, and accounting for the fact that analyze is still plenty fast on
> today's systems even at a tenfold increase, attached is a patch to
> change default_statistics_target from 10 to 100.

This is not happening without a whole lot more evidence (as in, more
than zero) to back up the choice of value.

            regards, tom lane

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

Предыдущее
От: Greg Sabino Mullane
Дата:
Сообщение: Better default_statistics_target
Следующее
От: ITAGAKI Takahiro
Дата:
Сообщение: Miscalculation in IsCheckpointOnSchedule()