Re: multivariate statistics (v25)

Simon Riggs <simon@2ndquadrant.com>

From: Simon Riggs <simon@2ndquadrant.com>

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

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

Date: 2017-04-05T18:52:39Z

Lists: pgsql-hackers

Attachments

create_statistics_lock_reduction.v1.patch (application/octet-stream) patch v1

On 5 April 2017 at 10:47, David Rowley <david.rowley@2ndquadrant.com> wrote:

>> I have some other comments.

Me too.


CREATE STATISTICS should take ShareUpdateExclusiveLock like ANALYZE.

This change is in line with other changes in this and earlier
releases. Comments and docs included.

Patch ready to be applied directly barring objections.

-- 
Simon Riggs                http://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