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

[Laurenz Albe <laurenz.albe@xxxxxxxxxxx>]

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