Re: ANALYZE sampling is too good

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: ANALYZE sampling is too good
Дата
Msg-id CAM3SWZSJwREmjVPuH8coJwLHAWoHDD0b9=hZdSamYRW55aZ+qg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ANALYZE sampling is too good  (Peter Geoghegan <pg@heroku.com>)
Список pgsql-hackers
On Tue, Dec 10, 2013 at 4:48 PM, Peter Geoghegan <pg@heroku.com> wrote:
> Why would I even mention that to a statistician? We want guidance. But
> yes, I bet I could give a statistician an explanation of statistics
> target that they'd understand without too much trouble.

Actually, I think that if we told a statistician about the statistics
target, his or her response would be: why would you presume to know
ahead of time what statistics target is going to be effective? I
suspect that the basic problem is that it isn't adaptive. I think that
if we could somehow characterize the quality of our sample as we took
it, and then cease sampling when we reached a certain degree of
confidence in its quality, that would be helpful. It might not even
matter that the sample was clustered from various blocks.


-- 
Peter Geoghegan



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

Предыдущее
От: Gavin Flower
Дата:
Сообщение: Re: ANALYZE sampling is too good
Следующее
От: Gavin Flower
Дата:
Сообщение: Re: ANALYZE sampling is too good