Cc: Tefft, Michael J ;
pgsql-general@lists.postgresql.org
Subject: Re: alter table xxx alter column yyy set (n_distinct= );
Works for me on Postgres 14 as well. Maybe you are looking at the wrong table?
Might help to show the exac
Works for me on Postgres 14 as well. Maybe you are looking at the wrong
table? Might help to show the exact steps you typed in.
On Mon, 2024-03-11 at 14:26 +, 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_inheri
negative, but none carry the value I attempted to
set
Thanks,
Mike Tefft
-Original Message-
From: Laurenz Albe
Sent: Monday, March 11, 2024 9:21 AM
To: Tefft, Michael J ;
pgsql-general@lists.postgresql.org
Subject: Re: alter table xxx alter column yyy set (n_distinct= );
On Mon
On Mon, 2024-03-11 at 12:36 +, Tefft, Michael J wrote:
> I have been struggling to set n_distinct on a few table columns, and confirm
> that my changes have actually been accepted.
>
> I have a 400-million row table with 81 partitions. PostgreSQL version is
> 14.11.
> Column p_id has 13 mil
I have been struggling to set n_distinct on a few table columns, and confirm
that my changes have actually been accepted.
I have a 400-million row table with 81 partitions. PostgreSQL version is 14.11.
Column p_id has 13 million distinct values but pg_stats says n_distinct is only
82k.
Column pi
