Re: pg_stats question

Tom Lane wrote:
> 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 ...
>


Right, but in this case I'm sure I have over 200 values.