From ebe7b7fbc792372f531fc11e14fa1c1dc8551da2 Mon Sep 17 00:00:00 2001 From: Michael Orlitzky Date: Wed, 14 Apr 2010 22:40:19 -0400 Subject: [PATCH] ANALYZE the blocks table after it is created. --- 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 a9dccd9..229cd66 100644 --- a/sql/combine-block-tables.sql +++ b/sql/combine-block-tables.sql @@ -22,3 +22,6 @@ 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; -- 2.43.2