[PERFORM] change sample size for statistics

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: [PERFORM] change sample size for statistics
Date: 2011-06-10 12:15:38
Message-ID: BANLkTik4st_UXVpjJYKcLp+wAtA+wKTe=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-06-10 12:33:42 Re: what is the best way of storing text+image documents in postgresql
Previous Message Robert Klemme 2011-06-10 10:02:50 Re: [GENERAL] [PERFORMANCE] expanding to SAN: which portion best to move

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2011-06-10 12:37:27 Re: 100% CPU Utilization when we run queries.
Previous Message tv 2011-06-10 12:10:06 Re: how much postgres can scale up?