postgres.git / summary / log / commit / refs

commit    db6de5b71ef2d91dde94fc0de8adf45372bc332d
Author:   Robert Haas <rhaas@postgresql.org>
Date:     Fri Jan 27 17:13:49 2012 +0000
First released in: 9.2.0

    Document that analyzing an empty table doesn't update the statistics.
    
    Per a suggestion from Sergey Konoplev


 doc/src/sgml/ref/analyze.sgml | 6 ++++++
 1 file changed, 6 insertions(+)

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>


[parent: cf3fff632629]