Joseph Shraibman <jks@selectacast.net> writes:
> Tom Lane wrote:
>> 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.
Still, ANALYZE might not have seen all of them within its sample set of
rows. There's inherently some sampling error involved in the process
(at least in 7.2 and later).
I don't believe 7.4 has any significant difference from 7.3 in this
area.
regards, tom lane