Re: multivariate statistics v9

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: multivariate statistics v9
Date: 2016-01-19 04:24:07
Message-ID: 569DBA67.9020403@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

Hi,

attached is v9 of the patch series, including mostly these changes:

1) CREATE STATISTICS cleanup

Firstly, I forgot to make the STATISTICS keyword unreserved again.
I've also removed additional stuff from the grammar that turned out
to be unnecessary / could be replaced with existing pieces.

2) making statistics schema-specific

Similarly to the other objects (e.g. types), statistics names are now
unique within a schema. This also means that the statistics may be
created using qualified name, and also may belong to a different
schema than a table.

It seems to me we probably also need to track owner, and only allow
the owner (or superuser / schema owner) to manipulate the statistics.

The initial intention was to inherit all this from the parent table,
but as we're designing this for the multi-table case, it's not
really working anymore.

3) adding IF [NOT] EXISTS to DROP STATISTICS / CREATE STATISTICS

4) basic documentation of the DDL commands

It's really simple at this point and some of the paragraphs are
still empty. I also think that we'll have to add stuff explaining
how to use statistics, not just docs for the DDL commands.

5) various fixes of the regression tests, related to the above

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
0001-teach-pull_-varno-varattno-_walker-about-RestrictInf.patch application/x-patch 1.4 KB
0002-shared-infrastructure-and-functional-dependencies.patch application/x-patch 105.6 KB
0003-clause-reduction-using-functional-dependencies.patch application/x-patch 48.1 KB
0004-multivariate-MCV-lists.patch application/x-patch 116.3 KB
0005-multivariate-histograms.patch application/x-patch 141.5 KB
0006-multi-statistics-estimation.patch application/x-patch 101.6 KB
0007-initial-version-of-ndistinct-conefficient-statistics.patch application/x-patch 18.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-01-19 04:24:51 Re: Combining Aggregates
Previous Message Robert Haas 2016-01-19 04:14:32 Re: Combining Aggregates