pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedDuplicate text in ANALYZE related to inheritance/parents
2+ messages / 1 participants
[nested] [flat]
* Duplicate text in ANALYZE related to inheritance/parents
@ 2022-09-01 03:43 Bruce Momjian <bruce@momjian.us>
2022-09-03 03:32 ` Re: Duplicate text in ANALYZE related to inheritance/parents Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 2+ messages in thread
From: Bruce Momjian @ 2022-09-01 03:43 UTC (permalink / raw)
To: pgsql-docs; +Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>
I noticed that our ANALYZE documentation has confusing duplicate text
related to the analyzing of inheritance trees. This patch fixes it.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson
Attachments:
[text/x-diff] analyze.diff (2.2K, ../../YxAqYijOsLzgLQgy@momjian.us/2-analyze.diff)
download | inline diff:
diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml
index b968f740cb..2ba115d1ad 100644
--- a/doc/src/sgml/ref/analyze.sgml
+++ b/doc/src/sgml/ref/analyze.sgml
@@ -250,12 +250,13 @@ ANALYZE [ VERBOSE ] [ <replaceable class="parameter">table_and_columns</replacea
</para>
<para>
- If the table being analyzed has one or more children,
- <command>ANALYZE</command> will gather statistics twice: once on the
- rows of the parent table only, and a second time on the rows of the
- parent table with all of its children. This second set of statistics
- is needed when planning queries that traverse the entire inheritance
- tree. The autovacuum daemon, however, will only consider inserts or
+ If the table being analyzed has inheritance children,
+ <command>ANALYZE</command> gathers two sets of statistics: one on the rows
+ of the parent table only, and a second including rows of both the parent
+ table and all of its children. This second set of statistics is needed when
+ planning queries that process the inheritance tree as a whole. The child
+ tables themselves are not individually analyzed in this case.
+ The autovacuum daemon, however, will only consider inserts or
updates on the parent table itself when deciding whether to trigger an
automatic analyze for that table. If that table is rarely inserted into
or updated, the inheritance statistics will not be up to date unless you
@@ -271,15 +272,6 @@ ANALYZE [ VERBOSE ] [ <replaceable class="parameter">table_and_columns</replacea
partitioning it's guaranteed to be empty.
</para>
- <para>
- By contrast, if the table being analyzed has inheritance children,
- <command>ANALYZE</command> gathers two sets of statistics: one on the rows
- of the parent table only, and a second including rows of both the parent
- table and all of its children. This second set of statistics is needed when
- planning queries that process the inheritance tree as a whole. The child
- tables themselves are not individually analyzed in this case.
- </para>
-
<para>
The autovacuum daemon does not process partitioned tables, nor does it
process inheritance parents if only the children are ever modified.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Duplicate text in ANALYZE related to inheritance/parents
2022-09-01 03:43 Duplicate text in ANALYZE related to inheritance/parents Bruce Momjian <bruce@momjian.us>
@ 2022-09-03 03:32 ` Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2022-09-03 03:32 UTC (permalink / raw)
To: pgsql-docs; +Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>
On Wed, Aug 31, 2022 at 11:43:30PM -0400, Bruce Momjian wrote:
> I noticed that our ANALYZE documentation has confusing duplicate text
> related to the analyzing of inheritance trees. This patch fixes it.
Patch applied back to PG 10.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-09-03 03:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-09-01 03:43 Duplicate text in ANALYZE related to inheritance/parents Bruce Momjian <bruce@momjian.us>
2022-09-03 03:32 ` Bruce Momjian <bruce@momjian.us>
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