Skip site navigation (1) Skip section navigation (2)

[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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-performance by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group