Joseph Shraibman <jks(at)selectacast(dot)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