change sample size for statistics

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема change sample size for statistics
Дата
Msg-id BANLkTik4st_UXVpjJYKcLp+wAtA+wKTe=g@mail.gmail.com
обсуждение исходный текст
Ответы Re: change sample size for statistics
Список pgsql-performance
Hi,

is there a way to change the sample size for statistics (that analyze gathers)?
It is said to be 10%. i would like to raise that, because we are getting bas estimations for n_distinct.

Cheers,

WBL

--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw

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

Предыдущее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: how much postgres can scale up?
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: 100% CPU Utilization when we run queries.