Re: multivariate statistics (v25)
David Rowley <david.rowley@2ndquadrant.com>
From: David Rowley <david.rowley@2ndquadrant.com>
To: Alvaro Herrera <alvherre@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-16T12:51:43Z
Lists: pgsql-hackers
Attachments
- extstats_pg_dump_and_comment_support.patch (application/octet-stream) patch
On 16 March 2017 at 09:45, Alvaro Herrera <alvherre@2ndquadrant.com> wrote: > 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. > Thanks for fixing. As you mentioned to me off-list about missing pg_dump support, I've gone and implemented that in the attached patch. I followed how pg_dump works for indexes, and created pg_get_statisticsextdef() in ruleutils.c. I was unsure if I should be naming this pg_get_statisticsdef() instead. I also noticed there's no COMMENT ON support either, so I added that too. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, 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