• Tomas Vondra's avatar
    Document autoanalyze limitations for partitioned tables · 6b262f35
    Tomas Vondra authored
    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
    6b262f35
maintenance.sgml 51 KB