[postgis-tickets] r17377 - change to use vacuum (analyze, verbose) instead of vacuum analyze verbose. The old format got remove in pg11

Regina Obe lr at pcorp.us
Mon Apr 8 09:27:23 PDT 2019


Author: robe
Date: 2019-04-08 09:27:22 -0700 (Mon, 08 Apr 2019)
New Revision: 17377

Modified:
   branches/2.5/doc/installation.xml
Log:
change to use vacuum (analyze, verbose) instead of vacuum analyze verbose.  The old format got remove in pg11

Modified: branches/2.5/doc/installation.xml
===================================================================
--- branches/2.5/doc/installation.xml	2019-04-07 06:40:18 UTC (rev 17376)
+++ branches/2.5/doc/installation.xml	2019-04-08 16:27:22 UTC (rev 17377)
@@ -1635,17 +1635,17 @@
 			</listitem>
 			<listitem><para>After you are done loading all data or at a stopping point, it's a good idea to analyze all the tiger tables to update the stats (include inherited stats)</para>
 			    <programlisting>SELECT install_missing_indexes();
-vacuum analyze verbose tiger.addr;
-vacuum analyze verbose tiger.edges;
-vacuum analyze verbose tiger.faces;
-vacuum analyze verbose tiger.featnames;
-vacuum analyze verbose tiger.place;
-vacuum analyze verbose tiger.cousub;
-vacuum analyze verbose tiger.county;
-vacuum analyze verbose tiger.state;
-vacuum analyze verbose tiger.zip_lookup_base;
-vacuum analyze verbose tiger.zip_state;
-vacuum analyze verbose tiger.zip_state_loc;</programlisting>
+vacuum (analyze, verbose) tiger.addr;
+vacuum (analyze, verbose) tiger.edges;
+vacuum (analyze, verbose) tiger.faces;
+vacuum (analyze, verbose) tiger.featnames;
+vacuum (analyze, verbose) tiger.place;
+vacuum (analyze, verbose) tiger.cousub;
+vacuum (analyze, verbose) tiger.county;
+vacuum (analyze, verbose) tiger.state;
+vacuum (analyze, verbose) tiger.zip_lookup_base;
+vacuum (analyze, verbose) tiger.zip_state;
+vacuum (analyze, verbose) tiger.zip_state_loc;</programlisting>
 			</listitem>
 		</orderedlist>
 		<sect3 id="convert_tiger_geocoder_extension"><title>Converting a Tiger Geocoder Regular Install to Extension Model</title>



More information about the postgis-tickets mailing list