Re: pg_stats question - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_stats question
Date
Msg-id 1837.1073513759@sss.pgh.pa.us
Whole thread Raw
In response to pg_stats question  (Joseph Shraibman <jks@selectacast.net>)
Responses Re: pg_stats question  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Joseph Shraibman <jks@selectacast.net> writes:
> I notice in 7.4.1 that if I do:
> ALTER TABLE <tab> ALTER <col> SET STATISTICS 100;
> ... that not necc. 100 values are stored in pg_stats, but in 7.3.4 it
> did.  Bug or expected behaviour?

It wasn't necessarily 100 values in 7.3, either.

As a trivial counterexample, if you have less than 100 distinct values
in your column, there definitely won't be 100 values in the
most-common-values list ...

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: PHP arrays and postgresql
Next
From: Joseph Shraibman
Date:
Subject: Re: pg_stats question