Content-Length: 262713 | pFad | http://github.com/postgrespro/postgres/commit/db6de5b71ef2d91dde94fc0de8adf45372bc332d

04 Document that analyzing an empty table doesn't update the statistics. · postgrespro/postgres@db6de5b · GitHub
Skip to content

Commit db6de5b

Browse files
committed
Document that analyzing an empty table doesn't update the statistics.
Per a suggestion from Sergey Konoplev
1 parent cf3fff6 commit db6de5b

File tree

1 file changed

+6
-0
lines changed

1 file changed

+6
-0
lines changed

doc/src/sgml/ref/analyze.sgml

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -190,6 +190,12 @@ ANALYZE [ VERBOSE ] [ <replaceable class="PARAMETER">table</replaceable> [ ( <re
190190
or updated, the inheritance statistics will not be up to date unless you
191191
run <command>ANALYZE</command> manually.
192192
</para>
193+
194+
<para>
195+
If the table being analyzed is completely empty, <command>ANALYZE</command>
196+
will not record new statistics for that table. Any existing statistics
197+
will be retained.
198+
</para>
193199
</refsect1>
194200

195201
<refsect1>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/db6de5b71ef2d91dde94fc0de8adf45372bc332d

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy