>> For heavy tailed distributions, it is possible for analyze to
>> duplicate histogram boundaries.
>
> 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.
 */

If this is expected, I'm also not sure what the use of maxmincount in
analyze is...

Thanks for the response,

Nathan

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to