| From: | Klaudie Willis <Klaudie(dot)Willis(at)protonmail(dot)com> |
|---|---|
| To: | Michael Lewis <mlewis(at)entrata(dot)com> |
| Cc: | Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: n_distinct off by a factor of 1000 |
| Date: | 2020-06-27 18:49:55 |
| Message-ID: | Rppkl60iUwpeM4puScNWQPo8DOnyI89wLuF9DoTavwcWAZjsx67a04nZtVoB9NHEvo6qhWYSIGRNZ5qw-POp6MTA_iNhFssqI51oOr8lZtE=@protonmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On the topic of n_distinct.
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.
K
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Klaudie Willis | 2020-06-27 19:28:42 | Re: n_distinct off by a factor of 1000 |
| Previous Message | Tom Lane | 2020-06-27 18:07:31 | Re: error messages (autovaccum canceled and syntax errors) while loading a DUMP |