X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/a73711f3cd5e4256ca7808dcca8f6fdb59fa716f..16bb0071350f66ff67308c5d33ae95dc1f2341ea:/lib-sql/tables.sql?ds=sidebyside

diff --git a/lib-sql/tables.sql b/lib-sql/tables.sql
index c254e2d4..9732c26c 100644
--- a/lib-sql/tables.sql
+++ b/lib-sql/tables.sql
@@ -154,6 +154,10 @@ CREATE INDEX idx_placex_osmid ON placex USING BTREE (osm_type, osm_id) {{db.tabl
 CREATE INDEX idx_placex_linked_place_id ON placex USING BTREE (linked_place_id) {{db.tablespace.address_index}} WHERE linked_place_id IS NOT NULL;
 CREATE INDEX idx_placex_rank_search ON placex USING BTREE (rank_search, geometry_sector) {{db.tablespace.address_index}};
 CREATE INDEX idx_placex_geometry ON placex USING GIST (geometry) {{db.tablespace.search_index}};
+CREATE INDEX idx_placex_geometry_buildings ON placex
+  USING GIST (geometry) {{db.tablespace.search_index}}
+  WHERE address is not null and rank_search = 30
+        and ST_GeometryType(geometry) in ('ST_Polygon','ST_MultiPolygon');
 CREATE INDEX idx_placex_geometry_placenode ON placex
   USING GIST (geometry) {{db.tablespace.search_index}}
   WHERE osm_type = 'N' and rank_search < 26