X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/9c152a030a9af829012f679e74625bd139bfb558..306b91004f6db6cc4500a59407c5da18f664443f:/lib-sql/indices.sql?ds=inline diff --git a/lib-sql/indices.sql b/lib-sql/indices.sql index 9130fb52..ed078895 100644 --- a/lib-sql/indices.sql +++ b/lib-sql/indices.sql @@ -30,6 +30,13 @@ CREATE INDEX IF NOT EXISTS idx_placex_geometry_reverse_lookupPolygon AND rank_address between 4 and 25 AND type != 'postcode' AND name is not null AND indexed_status = 0 AND linked_place_id is null; --- +-- used in reverse large area lookup +CREATE INDEX IF NOT EXISTS idx_placex_geometry_reverse_lookupPlaceNode + ON placex USING gist (ST_Buffer(geometry, reverse_place_diameter(rank_search))) + {{db.tablespace.search_index}} + WHERE rank_address between 4 and 25 AND type != 'postcode' + AND name is not null AND linked_place_id is null AND osm_type = 'N'; +--- CREATE INDEX IF NOT EXISTS idx_osmline_parent_place_id ON location_property_osmline USING BTREE (parent_place_id) {{db.tablespace.search_index}} WHERE parent_place_id is not null;