Re: hist boundary duplicates bug in head and 8.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: hist boundary duplicates bug in head and 8.3
Дата
Msg-id 12448.1231281011@sss.pgh.pa.us
обсуждение исходный текст
Ответ на hist boundary duplicates bug in head and 8.3  ("Nathan Boley" <npboley@gmail.com>)
Ответы Re: hist boundary duplicates bug in head and 8.3  ("Nathan Boley" <npboley@gmail.com>)
Список pgsql-hackers
"Nathan Boley" <npboley@gmail.com> writes:
> For heavy tailed distributions, it is possible for analyze to
> duplicate histogram boundaries.

I don't think this is a bug.  You've got values that didn't make it into
the MCV list, but nonetheless occupy multiple buckets' worth of space in
the remainder of the distribution.  They *should* appear multiple times
in the histogram.  If they didn't, the histogram would be understating
their frequency.
        regards, tom lane


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [GENERAL] ERROR: failed to find conversion function from "unknown" to text
Следующее
От: "Jaime Casanova"
Дата:
Сообщение: Re: parallel restore