pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / 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