X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/4fa349315b59bae789c77cbf2ffa0021d1231d64..ccb5cf155db45283377b44dcc0df63bfbe438168:/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.