Re: Expected accuracy of planner statistics

Поиск
Список
Период
Сортировка
От John D. Burger
Тема Re: Expected accuracy of planner statistics
Дата
Msg-id A1E93AA5-9312-4C95-A509-4434FDDD06BD@mitre.org
обсуждение исходный текст
Ответ на Re: Expected accuracy of planner statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Expected accuracy of planner statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:

> The information we've seen says that the only statistically
> reliable way
> to arrive at an accurate n_distinct estimate is to examine most of the
> table :-(.

> IIRC I picked an equation out of the literature partially on the basis
> of it being simple and fairly cheap to compute...

I'm very curious about this - can you recall where you got this, or
at least point me to where in the code this happens?

Thanks.

- John Burger
   MITRE

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

Предыдущее
От: km
Дата:
Сообщение: Re: 8.1.4 compile problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.1.4 compile problem