From d899b3b04cacff3f0b65305e426e0c839c22258d Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Wed, 8 Oct 2014 20:43:19 +0200 Subject: [PATCH] reintroduce index on gb_postcode --- sql/indices.src.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/sql/indices.src.sql b/sql/indices.src.sql index f715df8d..6e9c293e 100644 --- a/sql/indices.src.sql +++ b/sql/indices.src.sql @@ -28,3 +28,6 @@ CREATE INDEX idx_location_property_-partition-_centroid ON location_property_-pa -- end CREATE UNIQUE INDEX idx_place_osm_unique on place using btree(osm_id,osm_type,class,type); + + +CREATE INDEX idx_gb_postcode_postcode ON gb_postcode USING BTREE (postcode); -- 2.39.5