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

Поиск
Список
Период
Сортировка
От Maxim Boguk
Тема Re: BUG #17913: alter column set (n_distinct=...) on partition head doesn't work for declarative partitioned tables
Дата
Msg-id CAK-MWwRfF2_EMyBdspehezBe0+TV-m1tJh-QTnW2YasKXO5uvQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17913: alter column set (n_distinct=...) on partition head doesn't work for declarative partitioned tables  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-bugs
Дерево обсуждения


On Mon, May 1, 2023 at 2:41 PM David Rowley <dgrowleyml@gmail.com> wrote:
On Mon, 1 May 2023 at 15:03, PG Bug reporting form
<noreply@postgresql.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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: BUG #17913: alter column set (n_distinct=...) on partition head doesn't work for declarative partitioned tables
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #17804: Assertion failed in pg_stat after fetching from pg_stat_database and switching cache->snapshot