Document autoanalyze limitations for partitioned tables When dealing with partitioned tables, counters for partitioned tables are not updated when modifying child tables. This means autoanalyze may not update optimizer statistics for the parent relations, which can result in poor plans for some queries.
It's worth documenting this limitation, so that people are aware of it and can take steps to mitigate it (e.g. by setting up a script executing ANALYZE regularly). Backpatch to v10. Older branches are affected too, of couse, but we no longer maintain those. Author: Justin Pryzby Reviewed-by: Zhihong Yu, Tomas Vondra Backpatch-through: 10 Discussion: https://postgr.es/m/20210913035409.GA10647%40telsasoft.com Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/78ebfd885be563191d659d7a4ae230e199792e3f Modified Files -------------- doc/src/sgml/maintenance.sgml | 29 +++++++++++++++++++++++++++++ doc/src/sgml/ref/analyze.sgml | 32 +++++++++++++++++++++++++++++--- 2 files changed, 58 insertions(+), 3 deletions(-)
