change sample size for statistics - Mailing list pgsql-performance

From Willy-Bas Loos
Subject change sample size for statistics
Date
Msg-id BANLkTik4st_UXVpjJYKcLp+wAtA+wKTe=g@mail.gmail.com
Whole thread Raw
Responses Re: change sample size for statistics
List 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 by date:

Previous
From: tv@fuzzy.cz
Date:
Subject: Re: how much postgres can scale up?
Next
From: Craig Ringer
Date:
Subject: Re: 100% CPU Utilization when we run queries.