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: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-performance

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



"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

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-2017 The PostgreSQL Global Development Group