Re: multivariate statistics (v24)

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: David Fetter <david@fetter.org>, Dean Rasheed <dean.a.rasheed@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2017-03-04T07:03:32Z
Lists: pgsql-hackers
On Thu, Mar 2, 2017 at 8:35 AM, Tomas Vondra
<tomas.vondra@2ndquadrant.com> wrote:
> attached is v24 of the patch series, addressing most of the reported issues
> and comments (at least I believe so). The main changes are:
>
> 1) I've mostly abandoned the "multivariate" name in favor of "extended",
> particularly in places referring to stats stored in the pg_statistic_ext in
> general. "Multivariate" is now used only in places talking about particular
> types (e.g. multivariate histograms).
>
> The "extended" name is more widely used for this type of statistics, and the
> assumption is that we'll also add other (non-multivariate) types of
> statistics - e.g. statistics on custom expressions, or some for of join
> statistics.

Oh, I like that.  I found it hard to wrap my head around what
"multivariate" was supposed to mean, exactly.  I think "extended" will
be clearer.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Commits

  1. Collect and use multi-column dependency stats

  2. Implement SortSupport for macaddr data type

  3. Implement multivariate n-distinct coefficients

  4. Generate fmgr prototypes automatically