Re: hist boundary duplicates bug in head and 8.3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: hist boundary duplicates bug in head and 8.3
Date
Msg-id 12448.1231281011@sss.pgh.pa.us
Whole thread Raw
In response to hist boundary duplicates bug in head and 8.3  ("Nathan Boley" <npboley@gmail.com>)
Responses Re: hist boundary duplicates bug in head and 8.3  ("Nathan Boley" <npboley@gmail.com>)
List pgsql-hackers
"Nathan Boley" <npboley@gmail.com> writes:
> For heavy tailed distributions, it is possible for analyze to
> duplicate histogram boundaries.

I don't think this is a bug.  You've got values that didn't make it into
the MCV list, but nonetheless occupy multiple buckets' worth of space in
the remainder of the distribution.  They *should* appear multiple times
in the histogram.  If they didn't, the histogram would be understating
their frequency.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [GENERAL] ERROR: failed to find conversion function from "unknown" to text
Next
From: "Jaime Casanova"
Date:
Subject: Re: parallel restore