X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/e0a7b94e49cb4c47d0a42f0d8108f826e9de59f3..18800a1a82f29d6d1dda177dcd60715b2c060fb2:/lib-sql/indices.sql diff --git a/lib-sql/indices.sql b/lib-sql/indices.sql index ad6753c6..332cbb00 100644 --- a/lib-sql/indices.sql +++ b/lib-sql/indices.sql @@ -49,10 +49,6 @@ CREATE INDEX IF NOT EXISTS idx_postcode_postcode CREATE UNIQUE INDEX IF NOT EXISTS idx_place_osm_unique ON place USING btree(osm_id, osm_type, class, type) {{db.tablespace.address_index}}; - - CREATE INDEX IF NOT EXISTS idx_place_interpolations - ON place USING gist(geometry) {{db.tablespace.address_index}} - WHERE osm_type = 'W' and address ? 'interpolation'; {% endif %} -- Indices only needed for search.