On 22 March 2018 at 09:42, Dean Rasheed <dean.a.rash...@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
