Re: BUG #16521: n_distinct_inherited does not affect child partitions when set on main partition

Thanks for you thorough answer!

"n_distinct affects the statistics for the table itself, while n_distinct_inherited affects the statistics
gathered for the table plus its inheritance children."

I see that this text has multiple interpretations. I read it more like: while n_distinct_inherited affects the statistics gathered [by analyze] for the table plus [affects the statistics of] its inheritance children.

The core problem for me was that I had to set n_distinct manually on my individual partitions for the planner to choose a sane plan for queries on the declared partition. The data for a column was so skewed that the analyzers n_distinct was off by a factor of 1000X, which made all partitions do a table scan instead of index scan. In my mind, setting the declarative partition variable n_distinct_inherited would solve that; but obviously I am wrong on that.

Klaudie