X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/0e3252f045739cdc5cf845bf9467ea47dfd9bd9a..73c449b97b70e5d5f28db81993b09d86829d0fa5:/sql/indices_updates.src.sql diff --git a/sql/indices_updates.src.sql b/sql/indices_updates.src.sql index 175bfba2..6d4c968e 100644 --- a/sql/indices_updates.src.sql +++ b/sql/indices_updates.src.sql @@ -1,7 +1,7 @@ -- Indices used only during search and update. -- These indices are created only after the indexing process is done. -CREATE INDEX CONCURRENTLY idx_placex_pendingsector ON placex USING BTREE (rank_search,geometry_sector) {ts:address-index} where indexed_status > 0; +CREATE INDEX CONCURRENTLY idx_placex_pendingsector ON placex USING BTREE (rank_address,geometry_sector) {ts:address-index} where indexed_status > 0; CREATE INDEX CONCURRENTLY idx_location_area_country_place_id ON location_area_country USING BTREE (place_id) {ts:address-index};