Re: ANALYZE sampling is too good

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: ANALYZE sampling is too good
Дата
Msg-id CAM-w4HMrZTy8F56hbGpSEyrQ9hwiuuTm1pm6amh=MgK1yKhzrg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ANALYZE sampling is too good  (Greg Stark <stark@mit.edu>)
Список pgsql-hackers
On Mon, Dec 9, 2013 at 6:54 PM, Greg Stark <stark@mit.edu> wrote:
>
> This "some math" is straightforward basic statistics.  The 95th
> percentile confidence interval for a sample consisting of 300 samples
> from a population of a 1 million would be 5.66%. A sample consisting
> of 1000 samples would have a 95th percentile confidence interval of
> +/- 3.1%.

Incidentally I got this using an online sample size calculator. Google
turns up several but this one seems the easiest to use:
http://www.raosoft.com/samplesize.html


-- 
greg



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: About shared cache invalidation mechanism
Следующее
От: Andreas Karlsson
Дата:
Сообщение: Re: What are multixactids?