Re: Improving N-Distinct estimation by ANALYZE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Improving N-Distinct estimation by ANALYZE
Дата
Msg-id 17803.1137443903@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Improving N-Distinct estimation by ANALYZE  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> Tom has not spoken against checking for UNIQUE constraints: he is just
> pointing out that there never could be a constraint in the case I was
> identifying.

More generally, arguing for or against any system-wide change on the
basis of performance of compute_minimal_stats() is folly, because that
function is not used for any common datatypes.  (Ideally it'd never be
used at all.)
        regards, tom lane


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

Предыдущее
От: Manfred Koizar
Дата:
Сообщение: Re: Improving N-Distinct estimation by ANALYZE
Следующее
От: Tom Lane
Дата:
Сообщение: Anyone see a need for BTItem/HashItem?