X-Git-Url: http://gitweb.michael.orlitzky.com/?a=blobdiff_plain;f=sql%2Fcombine-block-tables.sql;h=229cd66ff8d00daa23dae47868627f86a5031339;hb=ebe7b7fbc792372f531fc11e14fa1c1dc8551da2;hp=3f492068379d93ae855b83da44af53cef3692e9a;hpb=348d73e051e750a1d750388aeba681074c1cc5e6;p=dead%2Fcensus-tools.git

diff --git a/sql/combine-block-tables.sql b/sql/combine-block-tables.sql
index 3f49206..229cd66 100644
--- a/sql/combine-block-tables.sql
+++ b/sql/combine-block-tables.sql
@@ -19,3 +19,9 @@ INSERT INTO blocks
 
 DROP TABLE sf1_blocks;
 DROP TABLE tiger_blocks;
+
+/* We have to re-create the GiST index on the new table as well. */
+CREATE INDEX idx_geometry_gist ON blocks USING gist(the_geom);
+
+/* And generate some statistics. */
+ANALYZE blocks;