[postgis-tickets] r17104 - change "vacuum analyze verbose" to "vacuum (analyze, verbose)" - the old syntax was removed in PostgreSQL 11
Regina Obe
lr at pcorp.us
Wed Dec 12 10:43:36 PST 2018
Author: robe
Date: 2018-12-12 22:43:36 -0800 (Wed, 12 Dec 2018)
New Revision: 17104
Modified:
trunk/doc/installation.xml
Log:
change "vacuum analyze verbose" to "vacuum (analyze, verbose)" - the old syntax was removed in PostgreSQL 11
Modified: trunk/doc/installation.xml
===================================================================
--- trunk/doc/installation.xml 2018-12-12 06:04:16 UTC (rev 17103)
+++ trunk/doc/installation.xml 2018-12-13 06:43:36 UTC (rev 17104)
@@ -2047,17 +2047,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