Re: ANALYZE sampling is too good

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: ANALYZE sampling is too good
Дата
Msg-id CAGTBQpY+znTQOujv3yV38NzF06OnK_wakudNb+ZRRL8JsG6QBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ANALYZE sampling is too good  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
On Thu, Dec 12, 2013 at 3:56 PM, Josh Berkus <josh@agliodbs.com> wrote:
>
> Estimated grouping should, however, affect MCVs.  In cases where we
> estimate that grouping levels are high, the expected % of observed
> values should be "discounted" somehow.  That is, with total random
> distribution you have a 1:1 ratio between observed frequency of a value
> and assumed frequency.  However, with highly grouped values, you might
> have a 2:1 ratio.

Cross validation can help there. But it's costly.



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: ANALYZE sampling is too good
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: ANALYZE sampling is too good