> I am not sure whether I am misinterpreting something, or if it is a bug > (probably former) however, when using partitions, are not > n_distinct_inherited supposed to propagate to the child partitions? It does > not seem to do so. (Yes, I run Analyze after setting the variable) I had to > set the n_distinct separately on all partitions to get the desired planer > behavior, but I thought that setting n_distinct_inherited was supposed to > prevent manually setting the partitions.
I follow up with a dbfiddle for this problem: https://www.db-fiddle.com/f/f5a2kPaq71G4yH8EAuXQV6/1 best regards K
