Re: multivariate statistics (v19)
Tomas Vondra <tomas.vondra@2ndquadrant.com>
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Michael Paquier <michael.paquier@gmail.com>
Cc: Tatsuo Ishii <ishii@postgresql.org>, Robert Haas <robertmhaas@gmail.com>,
david@pgmasters.net, Tom Lane <tgl@sss.pgh.pa.us>,
Alvaro Herrera <alvherre@2ndquadrant.com>,
Petr Jelinek <petr@2ndquadrant.com>, jeff.janes@gmail.com,
PostgreSQL mailing lists <pgsql-hackers@postgresql.org>
Date: 2016-08-05T17:38:05Z
Lists: pgsql-hackers
On 08/05/2016 06:24 AM, Michael Paquier wrote: > On Wed, Aug 3, 2016 at 10:58 AM, Tomas Vondra > <tomas.vondra@2ndquadrant.com> wrote: >> Attached is v19 of the "multivariate stats" patch series - essentially v18 >> rebased on top of current master. Aside from a few bug fixes, the main >> improvement is addition of SGML docs demonstrating the statistics in a way >> similar to the current "Row Estimation Examples" (and the docs are actually >> in the same section). I've tried to keep the right amount of technical >> detail (and pointing to the right README for additional details), but this >> may need improvements. I have not written docs explaining how statistics may >> be combined yet (more about this later). > > What we have here is quite something: > $ git diff master --stat | tail -n1 > 77 files changed, 12809 insertions(+), 65 deletions(-) > I will try to get familiar on the topic and added myself as a reviewer > of this patch. Hopefully I'll get feedback soon. Yes, it's a large patch. Although 25% of the insertions are SGML docs, regression tests and READMEs, and large part of the remaining ~9k insertions are comments. But it may still be overwhelming, no doubt about that. FWIW, if someone is interested in the patch but is unsure where to start, I'm ready to help with that as much as possible. For example if you happen to go to PostgresOpen, feel free to drag me to a corner and ask me as many questions as you want ... regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
Collect and use multi-column dependency stats
- 2686ee1b7ccf 10.0 landed
-
Implement SortSupport for macaddr data type
- f90d23d0c518 10.0 cited
-
Implement multivariate n-distinct coefficients
- 7b504eb282ca 10.0 landed
-
Generate fmgr prototypes automatically
- 352a24a1f9d6 10.0 cited