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 | Resend email |
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 |
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 |