Re: v13: show extended stats target in \d

On Tue, Sep 01, 2020 at 05:08:25PM -0400, Alvaro Herrera wrote:
>+1 on fixing this, since the ability to change stats target is new in
>pg13.
>
>On 2020-Aug-31, Justin Pryzby wrote:
>
>> Maybe it should have a comma, like ", STATISTICS %s"?
>
>It does need some separator. Maybe a comma is sufficient, but I'm not
>sure: that will fail when we add cross-relation stats, because the
>FROM clause will have more relations and possibly have commas too.
>
> Table "public.ab1"
> Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
>--------+---------+-----------+----------+---------+---------+--------------+-------------
> a | integer | | | | plain | |
> b | integer | | | | plain | |
>Statistics objects:
> "public"."ab1_a_b_stats" (ndistinct, dependencies, mcv) ON a, b FROM ab1
>
>
>> Also, now I wonder if CREATE STATISTICS should support some syntax to set the
>> initial target. Like:
>>
>> |CREATE STATISTICS abstats ON a,b FROM child.abc_202006 WITH(STATISTICS 111);
>
>Umm, if true (on which I'm not sold), maybe it should appear in the
>parenthesized list that currently is just the stats type list:
>
> |CREATE STATISTICS abstats (STATISTICS 111) ON a,b FROM child.abc_202006;
>
>I'm not really convinced we need this.
>

Me neither. IMHO it's somewhat similar to per-column statistics target,
where we don't allow specifying that in CREATE TABLE and you have to do

ALTER TABLE ... ALTER COLUMN ... SET STATISTICS n;

as a separate step.

regards

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