"Nathan Boley" <[email protected]> writes:
>> I don't think this is a bug.
> hmmm... Well, I assumed it was a bug from a comment in analyze.
> From ( near ) line 2130 in analyze.c
> * least 2 instances in the sample. Also, we won't suppress values
> * that have a frequency of at least 1/K where K is the intended
> * number of histogram bins; such values might otherwise cause us to
> * emit duplicate histogram bin boundaries.
That's talking about a case where we have a choice whether to include a
value in the MCV list or not. Once the MCV list is maxed out, we can't
do anything to avoid duplicates.
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
