Re: multivariate statistics (v25)

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, David Fetter <david(at)fetter(dot)org>, dean(dot)a(dot)rasheed(at)gmail(dot)com, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: multivariate statistics (v25)
Date: 2017-03-16 12:51:43
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-hackers

On 16 March 2017 at 09:45, Alvaro Herrera <alvherre(at)2ndquadrant(dot)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
PostgreSQL Development, 24x7 Support, Training & Services

Attachment Content-Type Size
extstats_pg_dump_and_comment_support.patch application/octet-stream 19.2 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2017-03-16 12:53:36 Re: Patch: Write Amplification Reduction Method (WARM)
Previous Message Ashutosh Bapat 2017-03-16 12:48:38 Re: Parallel Append implementation