pgsql: Doc: clarify n_distinct_inherited setting
| От | David Rowley |
|---|---|
| Тема | pgsql: Doc: clarify n_distinct_inherited setting |
| Дата | |
| Msg-id | E1v8P97-001XdQ-1P@gemulon.postgresql.org обсуждение исходный текст |
| Список | pgsql-committers |
Doc: clarify n_distinct_inherited setting There was some confusion around how to adjust the n_distinct estimates for partitioned tables. Here we try and clarify that n_distinct_inherited needs to be adjusted rather than n_distinct. Also fix some slightly misleading text which was talking about table size rather than table rows, fix a grammatical error, and adjust some text which indicated that ANALYZE was performing calculations based on the n_distinct settings. Really it's the query planner that does this and ANALYZE only stores the overridden n_distinct estimate value in pg_statistic. Author: David Rowley <dgrowleyml@gmail.com> Reviewed-by: David G. Johnston <david.g.johnston@gmail.com> Reviewed-by: Chao Li <li.evan.chao@gmail.com> Backpatch-through: 13 Discussion: https://postgr.es/m/CAApHDvrL7a-ZytM1SP8Uk9nEw9bR2CPzVb+uP+bcNj=_q-ZmVw@mail.gmail.com Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/c3b9e565137b187cd9b271fff366075020df6b1d Modified Files -------------- doc/src/sgml/ref/alter_table.sgml | 34 ++++++++++++++++------------------ 1 file changed, 16 insertions(+), 18 deletions(-)
В списке pgsql-committers по дате отправления: