Re: Improving N-Distinct estimation by ANALYZE

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Improving N-Distinct estimation by ANALYZE
Дата
Msg-id 43BCBD27.5080002@agliodbs.com
обсуждение исходный текст
Ответ на Re: Improving N-Distinct estimation by ANALYZE  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Folks,

> Nope, it's definitely proportional.   As a simple example, a sample of 
> 500 rows in a table of 1000 rows should yeild stats estimates with 90%+ 
> accuracy.  But a sample of 500 rows in a 600,000,000 row table is so 
> small as to be nearly useless; it's quite possible to get all the same 
> value in a random sample of < 0.1% even on a column with a D/N of 0.001. 

I meant "a D/N of 0.1".  Sorry.

--Josh


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Improving N-Distinct estimation by ANALYZE
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Improving N-Distinct estimation by ANALYZE