pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Document autoanalyze limitations for partitioned tables 6+ messages / 1 participants [nested] [flat]
* pgsql: Document autoanalyze limitations for partitioned tables @ 2022-03-28 13:01 Tomas Vondra <tomas.vondra@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Tomas Vondra @ 2022-03-28 13:01 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Document autoanalyze limitations for partitioned tables @ 2022-03-28 13:01 Tomas Vondra <tomas.vondra@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Tomas Vondra @ 2022-03-28 13:01 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/6b262f353ef710704a9388d32924b8c10c7e6eaa Modified Files -------------- doc/src/sgml/maintenance.sgml | 29 +++++++++++++++++++++++++++++ doc/src/sgml/ref/analyze.sgml | 32 +++++++++++++++++++++++++++++--- 2 files changed, 58 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Document autoanalyze limitations for partitioned tables @ 2022-03-28 13:01 Tomas Vondra <tomas.vondra@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Tomas Vondra @ 2022-03-28 13:01 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Document autoanalyze limitations for partitioned tables @ 2022-03-28 13:02 Tomas Vondra <tomas.vondra@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Tomas Vondra @ 2022-03-28 13:02 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b36c2719132459768b29f5ca653b34f753c37329 Modified Files -------------- doc/src/sgml/maintenance.sgml | 29 +++++++++++++++++++++++++++++ doc/src/sgml/ref/analyze.sgml | 32 +++++++++++++++++++++++++++++--- 2 files changed, 58 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Document autoanalyze limitations for partitioned tables @ 2022-03-28 13:02 Tomas Vondra <tomas.vondra@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Tomas Vondra @ 2022-03-28 13:02 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_11_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/0fc2455edbda035df87bbb1ea2091eb87f94bb99 Modified Files -------------- doc/src/sgml/maintenance.sgml | 29 +++++++++++++++++++++++++++++ doc/src/sgml/ref/analyze.sgml | 32 +++++++++++++++++++++++++++++--- 2 files changed, 58 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Document autoanalyze limitations for partitioned tables @ 2022-03-28 13:02 Tomas Vondra <tomas.vondra@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Tomas Vondra @ 2022-03-28 13:02 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_10_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/c1e9cfaef9759442dde94f23275b4969b0a631b7 Modified Files -------------- doc/src/sgml/maintenance.sgml | 29 +++++++++++++++++++++++++++++ doc/src/sgml/ref/analyze.sgml | 32 +++++++++++++++++++++++++++++--- 2 files changed, 58 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2022-03-28 13:02 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-03-28 13:01 pgsql: Document autoanalyze limitations for partitioned tables Tomas Vondra <tomas.vondra@postgresql.org> 2022-03-28 13:01 pgsql: Document autoanalyze limitations for partitioned tables Tomas Vondra <tomas.vondra@postgresql.org> 2022-03-28 13:01 pgsql: Document autoanalyze limitations for partitioned tables Tomas Vondra <tomas.vondra@postgresql.org> 2022-03-28 13:02 pgsql: Document autoanalyze limitations for partitioned tables Tomas Vondra <tomas.vondra@postgresql.org> 2022-03-28 13:02 pgsql: Document autoanalyze limitations for partitioned tables Tomas Vondra <tomas.vondra@postgresql.org> 2022-03-28 13:02 pgsql: Document autoanalyze limitations for partitioned tables Tomas Vondra <tomas.vondra@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox