Hi,
I'ver been wondering how to set the number of rows that are scanned by
analyze. (I want to increase it)
I couln't find it at first but when i read closer i found that is does:
"The largest statistics target among the columns being analyzed
determines the number of table rows sampled to prepare
On Mon, Aug 01, 2011 at 04:42:23PM +0200, Willy-Bas Loos wrote:
> Hi,
>
> I'ver been wondering how to set the number of rows that are scanned by
> analyze. (I want to increase it)
> I couln't find it at first but when i read closer i found that is does:
> "The largest statistics target among the c
Willy-Bas Loos writes:
> "The largest statistics target among the columns being analyzed
> determines the number of table rows sampled to prepare the
> statistics."
> (http://www.postgresql.org/docs/8.4/interactive/sql-analyze.html)
> My question is *HOW* does it "detirmine the number of table ro
Ok, so 300 times the statistics target!
Thanks a lot for the exact code and formula!
On Mon, Aug 1, 2011 at 4:49 PM, Tom Lane wrote:
> Why? This is purely an implementation detail. From the user's
> viewpoint, either the stats are good enough or they're not --- the exact
> number of rows sample