On Wed, Dec 2, 2015 at 10:20 AM, Shulgin, Oleksandr <
> On Tue, Dec 1, 2015 at 7:00 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
>> "Shulgin, Oleksandr" <oleksandr.shul...@zalando.de> writes:
>> > This post summarizes a few weeks of research of ANALYZE statistics
>> > distribution on one of our bigger production databases with some
>> > data and proposes a patch to rectify some of the oddities observed.
>> Please add this to the 2016-01 commitfest ...
> Added: https://commitfest.postgresql.org/8/434/
It would be great if some folks could find a moment to run the queries I
was showing on their data to confirm (or refute) my findings, or to
contribute to the picture in general.
As I was saying, the queries were designed in such a way that even
unprivileged user can run them (the results will be limited to the stats
data available to that user, obviously; and for custom-tailored statstarget
one still needs superuser to join the pg_statistic table directly). Also,
on the scale of ~30k attribute statistics records, the queries take only a
few seconds to finish.