diff options
author | Tomas Vondra <tomas.vondra@postgresql.org> | 2021-03-26 22:34:53 +0100 |
---|---|---|
committer | Tomas Vondra <tomas.vondra@postgresql.org> | 2021-03-26 22:37:45 +0100 |
commit | 67251c82af87865989eb90c7e8f4546cc0d66e6d (patch) | |
tree | 366763a8cae2979a6be0b48d83caa0ab6e16bf82 /contrib/postgres_fdw/postgres_fdw.c | |
parent | c8622999b7fe53741304f2aca73560aade6557d2 (diff) | |
download | postgresql-67251c82af87865989eb90c7e8f4546cc0d66e6d.tar.gz postgresql-67251c82af87865989eb90c7e8f4546cc0d66e6d.zip |
Fix ndistinct estimates with system attributes
When estimating the number of groups using extended statistics, the code
was discarding information about system attributes. This led to strange
situation that
SELECT 1 FROM t GROUP BY ctid;
could have produced higher estimate (equal to pg_class.reltuples) than
SELECT 1 FROM t GROUP BY a, b, ctid;
with extended statistics on (a,b). Fixed by retaining information about
the system attribute.
Backpatch all the way to 10, where extended statistics were introduced.
Author: Tomas Vondra
Backpatch-through: 10
Diffstat (limited to 'contrib/postgres_fdw/postgres_fdw.c')
0 files changed, 0 insertions, 0 deletions