On 22 March 2018 at 09:42, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
> Improve ANALYZE's strategy for finding MCVs.
> Thus it tends to produce
> fewer MCVs than the previous code for uniform distributions, and more
> for non-uniform distributions, reducing estimation errors in both
> cases. In addition, the algorithm responds better to increasing the
> statistics target, allowing more values to be included in the MCV list
> when more of the table is sampled.
>
> Jeff Janes, substantially modified by me. Reviewed by John Naylor and
> Tomas Vondra.
git praise --all
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services