From 4ab0591f5fd8019a0e847a11d1d87b5481f5d28a Mon Sep 17 00:00:00 2001
From: Michael Orlitzky <michael@orlitzky.com>
Date: Wed, 14 Apr 2010 21:27:20 -0400
Subject: [PATCH] Add a GiST index on blocks.the_geom after we combine the
 TIGER/SF1 tables.

---
 sql/combine-block-tables.sql | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/sql/combine-block-tables.sql b/sql/combine-block-tables.sql
index 3f49206..a9dccd9 100644
--- a/sql/combine-block-tables.sql
+++ b/sql/combine-block-tables.sql
@@ -19,3 +19,6 @@ 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);
-- 
2.43.2