Re: hist boundary duplicates bug in head and 8.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: hist boundary duplicates bug in head and 8.3
Дата
Msg-id 13427.1231285209@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: hist boundary duplicates bug in head and 8.3  ("Nathan Boley" <npboley@gmail.com>)
Ответы Re: hist boundary duplicates bug in head and 8.3  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
"Nathan Boley" <npboley@gmail.com> writes:
>> I don't think this is a bug.

> hmmm... Well, I assumed it was a bug from a comment in analyze.

> From ( near ) line 2130 in analyze.c

>  * least 2 instances in the sample.  Also, we won't suppress values
>  * that have a frequency of at least 1/K where K is the intended
>  * number of histogram bins; such values might otherwise cause us to
>  * emit duplicate histogram bin boundaries.

That's talking about a case where we have a choice whether to include a
value in the MCV list or not.  Once the MCV list is maxed out, we can't
do anything to avoid duplicates.
        regards, tom lane


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

Предыдущее
От: "Nathan Boley"
Дата:
Сообщение: Re: hist boundary duplicates bug in head and 8.3
Следующее
От: "Stephen R. van den Berg"
Дата:
Сообщение: Re: Runaway backend at 100% CPU PostgreSQL v8.3.5