X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/7a11e17008efa632eac9fd65b8599814681cb03d..79b30a8c0f695746b3ed79e4fb484accd5bf9bec:/sql/indices.src.sql

diff --git a/sql/indices.src.sql b/sql/indices.src.sql
index 37d53a05..4685ae2f 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);
