Re: alter table xxx alter column yyy set (n_distinct=nnnn );

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "Tefft, Michael J" <Michael(dot)J(dot)Tefft(at)snapon(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: alter table xxx alter column yyy set (n_distinct=nnnn );
Date: 2024-03-11 14:45:13
Message-ID: 26589e7901c89df0daaea5a937b82f1abaac15a8.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2024-03-11 at 14:26 +0000, Tefft, Michael J wrote:
> I tried setting
>
> alter table ctrg.xxx alter column p_id set (n_distinct_inherited=-0.033 );
> alter table ctrg.xxx alter column pi_id set (n_distinct_inherited=-0.045 );
> alter table ctrg.xxx alter column i_id set (n_distinct_inherited=-0.0002 );
>
> I then ran
> analyze xxx;
> but saw no change in pg_stats.n_distinct for xxx.

Well, it works on my PostgreSQL v16.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-03-11 15:04:23 Re: could not open file "global/pg_filenode.map": Operation not permitted
Previous Message Tefft, Michael J 2024-03-11 14:26:23 RE: alter table xxx alter column yyy set (n_distinct=nnnn );