Re: [HACKERS] PATCH: multivariate histograms and MCV lists
Tomas Vondra <tomas.vondra@2ndquadrant.com>
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Dean Rasheed <dean.a.rasheed@gmail.com>, Bruce Momjian <bruce@momjian.us>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>,
Andres Freund <andres@anarazel.de>,
Thomas Munro <thomas.munro@enterprisedb.com>,
Mark Dilger <hornschnorter@gmail.com>,
Adrien Nayrat <adrien.nayrat@dalibo.com>,
Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-04-07T20:44:42Z
Lists: pgsql-hackers
On 04/07/2018 07:52 PM, Dean Rasheed wrote: > On 7 April 2018 at 15:12, Bruce Momjian <bruce@momjian.us> wrote: >> Uh, where are we on this patch? It isn't going to make it into PG 11? >> Feature development for this has been going on for years. > > Unfortunately, I think there's no way that this will be ready for > PG11. So far, I have only read parts of the patch, focusing mainly on > the planner changes, and how it will make use of the new statistics. I > think there are still issues to work out in that area, although I > haven't read the latest version yet, I have some doubts about the new > approach described. > > Looking back at the history of this patch, it appears to have moved > through all 4 PG11 commitfests with fairly minimal review, never > becoming Ready for Committer. That's a real shame because I agree that > it's an important feature, but IMO it's not yet in a committable > state. I feel bad saying that, because the patch hasn't really had a > fair chance to-date, despite Tomas' efforts and quick responses to all > review comments. > Well, yeah. The free fall through all PG11 commitfests is somewhat demotivating :-/ I certainly agree the patch is not committable in the current state. I don't think it's in terrible shape, but I'm sure there are still some dubious parts. I certainly know about a few. > At this stage though, all I can say is that I'll make every effort to > keep reviewing it, and I hope Tomas will persist, so that it has a > better chance in PG12. > Thank you for the effort and for the reviews, of course. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
Convert pre-existing stats_ext tests to new style
- dbb984128ebf 12.0 landed
-
Add support for multivariate MCV lists
- 7300a699502f 12.0 landed
-
Improve ANALYZE's strategy for finding MCVs.
- b5db1d93d2a6 11.0 cited
-
Clone extended stats in CREATE TABLE (LIKE INCLUDING ALL)
- 5564c1181548 11.0 cited
-
Try again to fix accumulation of parallel worker instrumentation.
- 8526bcb2df76 11.0 cited
-
Adjust psql \d query to avoid use of @> operator.
- 471d55859c11 11.0 cited
-
Message style fixes
- 821fb8cdbf70 11.0 cited
-
Add security checks to selectivity estimation functions
- e2d4ef8de869 10.0 cited