Re: multivariate statistics (v25)

Alvaro Herrera <alvherre@2ndquadrant.com>

From: Alvaro Herrera <alvherre@2ndquadrant.com>

To: David Rowley <david.rowley@2ndquadrant.com>

Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>, David Fetter <david@fetter.org>, dean.a.rasheed@gmail.com, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2017-03-16T22:20:33Z

Lists: pgsql-hackers

Attachments

0001-teach-pull_-varno-varattno-_walker-about-RestrictInf.patch.gz (application/x-gunzip) patch 0001
0002-PATCH-shared-infrastructure-and-ndistinct-coefficien.patch.gz (application/x-gunzip) patch 0002
0003-Add-COMMENT-ON-STATISTICS-support.patch.gz (application/x-gunzip) patch 0003
0004-pg_dump-support-for-pg_statistic_ext.patch.gz (application/x-gunzip) patch 0004
0005-PATCH-functional-dependencies-only-the-ANALYZE-part.patch.gz (application/x-gunzip) patch 0005
0006-PATCH-selectivity-estimation-using-functional-depend.patch.gz (application/x-gunzip) patch 0006
0007-PATCH-multivariate-MCV-lists.patch.gz (application/x-gunzip) patch 0007
0008-PATCH-multivariate-histograms.patch.gz (application/x-gunzip) patch 0008
0009-WIP-use-ndistinct-for-selectivity-estimation-in-clau.patch.gz (application/x-gunzip) patch 0009
0010-WIP-allow-using-multiple-statistics-in-clauselist_se.patch.gz (application/x-gunzip) patch 0010
0011-WIP-psql-tab-completion-basics.patch.gz (application/x-gunzip) patch 0011

Here's a rebased series on top of today's a3eac988c267.  I call this
v28.

I put David's pg_dump and COMMENT patches as second in line, just after
the initial infrastructure patch.  I suppose those three have to be
committed together, while the others (which add support for additional
statistic types) can rightly remain as separate commits.

(I think I lost some regression test files.  I couldn't make up my mind
about putting each statistic type's tests in a separate file, or all
together in stats_ext.sql.)

-- 
Álvaro Herrera                https://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