X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/9f64c34f1a579cca7aa144365e5519fce9e47391..9a1f891998d9b56481b96b5201317494987302e1:/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.