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 ------ master Details ------- https://git.postgresql.org/pg/commitdiff/61fa6ca79b3c566f44831a33bb226f7358ed4511 Modified Files -------------- doc/src/sgml/maintenance.sgml | 29 +++++++++++++++++++++++++++++ doc/src/sgml/ref/analyze.sgml | 32 +++++++++++++++++++++++++++++--- 2 files changed, 58 insertions(+), 3 deletions(-)
