X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/dc7cfd1708da6fceb268d2efaaf92ef513a20234..9abf2c248ed27a410b3fad92daf4392e660b1c66:/lib-sql/indices.sql

diff --git a/lib-sql/indices.sql b/lib-sql/indices.sql
index 9c31f556..8c176fdf 100644
--- a/lib-sql/indices.sql
+++ b/lib-sql/indices.sql
@@ -81,6 +81,9 @@ CREATE INDEX IF NOT EXISTS idx_postcode_postcode
     type TEXT,
     deferred BOOLEAN
    );
+---
+  CREATE INDEX IF NOT EXISTS idx_location_postcode_parent_place_id
+    ON location_postcode USING BTREE (parent_place_id) {{db.tablespace.address_index}};
 {% endif %}
 
 -- Indices only needed for search.