| From: | Klaudie Willis <Klaudie(dot)Willis(at)protonmail(dot)com> |
|---|---|
| To: | |
| Cc: | Michael Lewis <mlewis(at)entrata(dot)com>, 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 19:28:42 |
| Message-ID: | -80UM46RdRZs8iKBV88cCySSbiaUvpSPMDWA2hE5ApvQdeV4uOVErw5rJYtakUAjHjYCygWX3SlHhrL9y7tB9klZJCxDBZTCUzi1SnHZ9uc=@protonmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-06-27 22:09:54 | Re: error messages (autovaccum canceled and syntax errors) while loading a DUMP |
| Previous Message | Klaudie Willis | 2020-06-27 18:49:55 | Re: n_distinct off by a factor of 1000 |