diff options
| author | Tomas Vondra <tomas.vondra@postgresql.org> | 2022-03-28 14:27:36 +0200 |
|---|---|---|
| committer | Tomas Vondra <tomas.vondra@postgresql.org> | 2022-03-28 14:30:00 +0200 |
| commit | 61fa6ca79b3c566f44831a33bb226f7358ed4511 (patch) | |
| tree | 1f931e4dbe0cdd54ad0bc75ef3afb79221245c18 /src/include/executor/nodeModifyTable.h | |
| parent | e26114c817b610424010cfbe91a743f591246ff1 (diff) | |
| download | postgresql-61fa6ca79b3c566f44831a33bb226f7358ed4511.tar.gz postgresql-61fa6ca79b3c566f44831a33bb226f7358ed4511.zip | |
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
Diffstat (limited to 'src/include/executor/nodeModifyTable.h')
0 files changed, 0 insertions, 0 deletions