[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