From: Sarah Hoffmann Date: Wed, 8 Oct 2014 18:43:19 +0000 (+0200) Subject: reintroduce index on gb_postcode X-Git-Tag: v2.4.0~83 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/d899b3b04cacff3f0b65305e426e0c839c22258d reintroduce index on gb_postcode --- 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);