Re: pg_stats question

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