From db6de5b71ef2d91dde94fc0de8adf45372bc332d Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Fri, 27 Jan 2012 12:13:49 -0500 Subject: [PATCH] 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 7545fa5d86..8c9057beb9 100644 --- a/doc/src/sgml/ref/analyze.sgml +++ b/doc/src/sgml/ref/analyze.sgml @@ -190,6 +190,12 @@ ANALYZE [ VERBOSE ] [ table [ ( ANALYZE manually. + + + If the table being analyzed is completely empty, ANALYZE + will not record new statistics for that table. Any existing statistics + will be retained. + -- 2.39.5