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
