Re: BUG #17913: alter column set (n_distinct=...) on partition head doesn't work for declarative partitioned tables

On Mon, May 1, 2023 at 2:41 PM David Rowley <dgrowleyml(at)gmail(dot)com> wrote:

> On Mon, 1 May 2023 at 15:03, PG Bug reporting form
> <noreply(at)postgresql(dot)org> wrote:
> > I found that the
> > alter table sometable alter somecolumn set (n_distinct=...);
> > Doesn't affect distinct values estimation if sometable - declarative
> > partitioned table.
>
> It might not be that intuitive, but n_distinct_inherited is the option for
> that.
>
> Maybe the documentation [1] should mention partition partitions as
> well as "inheritance children" is this isn't clear.
>
> David
>
> [1] https://www.postgresql.org/docs/current/sql-altertable.html
>

Thank you very much, I don't know how I missed this moment in documentation.

--
Maxim Boguk
Senior Postgresql DBA
https://dataegret.com/

Phone UA: +380 99 143 0000
Phone AU: +61 45 218 5678