aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/analyze.sgml13
1 files changed, 12 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml
index 1f2e4c1bad7..98dcbf0ed80 100644
--- a/doc/src/sgml/ref/analyze.sgml
+++ b/doc/src/sgml/ref/analyze.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/analyze.sgml,v 1.29 2010/04/03 07:22:57 petere Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/analyze.sgml,v 1.30 2010/06/15 18:43:35 rhaas Exp $
PostgreSQL documentation
-->
@@ -176,6 +176,17 @@ ANALYZE [ VERBOSE ] [ <replaceable class="PARAMETER">table</replaceable> [ ( <re
<command>ALTER TABLE ... ALTER COLUMN ... SET (n_distinct = ...)</>
(see <xref linkend="sql-altertable">).
</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. The autovacuum daemon, however,
+ will only consider inserts or updates on the parent table when deciding
+ whether to trigger an automatic analyze. If that table is rarely
+ inserted into or updated, the inheritance statistics will not be up to date
+ unless you run <command>ANALYZE</command> manually.
+ </para>
</refsect1>
<refsect1>