Horton

Re: multivariate statistics (v25)

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es
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-15T20:45:18Z
Lists: pgsql-hackers

Attachments

Here's another version of 0002 after cleaning up almost everything from
David's review.  I also added tests for ALTER STATISTICS in
sql/alter_generic.sql which made me realize there were three crasher bug
in here; fixed all those.  It also made me realize that psql's \d was a
little bit too generous with dropped columns in a stats object.  That
should all behave better now.

One thing I didn't do was change StatisticExtInfo to use a bitmapset
instead of int2vector.  I think it's a good idea to do so.

I'll go rebase the followup patches now.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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