aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2012-01-27 12:13:49 -0500
committerRobert Haas <rhaas@postgresql.org>2012-01-27 12:14:23 -0500
commitdb6de5b71ef2d91dde94fc0de8adf45372bc332d (patch)
tree9ba285cbb3550a5e14f5015c09d0dbfef6681e77
parentcf3fff6326299deca77c1387df31d24aea36e2e1 (diff)
downloadpostgresql-db6de5b71ef2d91dde94fc0de8adf45372bc332d.tar.gz
postgresql-db6de5b71ef2d91dde94fc0de8adf45372bc332d.zip
Document that analyzing an empty table doesn't update the statistics.
Per a suggestion from Sergey Konoplev
-rw-r--r--doc/src/sgml/ref/analyze.sgml6
1 files changed, 6 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml
index 7545fa5d869..8c9057beb91 100644
--- a/doc/src/sgml/ref/analyze.sgml
+++ b/doc/src/sgml/ref/analyze.sgml
@@ -190,6 +190,12 @@ ANALYZE [ VERBOSE ] [ <replaceable class="PARAMETER">table</replaceable> [ ( <re
or updated, the inheritance statistics will not be up to date unless you
run <command>ANALYZE</command> manually.
</para>
+
+ <para>
+ If the table being analyzed is completely empty, <command>ANALYZE</command>
+ will not record new statistics for that table. Any existing statistics
+ will be retained.
+ </para>
</refsect1>
<refsect1>