Re: [HACKERS] PATCH: multivariate histograms and MCV lists

Tomas Vondra <tomas.vondra@2ndquadrant.com>

From: Tomas Vondra <tomas.vondra@2ndquadrant.com>

To: Thomas Munro <thomas.munro@enterprisedb.com>

Cc: Mark Dilger <hornschnorter@gmail.com>, Adrien Nayrat <adrien.nayrat@dalibo.com>, Pg Hackers <pgsql-hackers@postgresql.org>

Date: 2018-02-24T22:01:59Z

Lists: pgsql-hackers

Attachments

0001-Keep-information-about-already-estimated-cl-20180224.patch.gz (application/gzip) patch 0001
0002-multivariate-MCV-lists-20180224.patch.gz (application/gzip) patch 0002
0003-multivariate-histograms-20180224.patch.gz (application/gzip) patch 0003

Hi,

Attached is an updated version of the patch, fixing some minor bitrot
and duplicate OIDs.

Sadly, this patch series does not seem to move forward very much, and
I'm not sure how to change that :-/ But I'd like to point out that while
those new statistics are still per-table, we might use them to improve
join estimates (which is kinda the elephant in the room, when it comes
to estimates) similarly to what eqjoinsel() does with per-column stats.


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