]> git.openstreetmap.org Git - nominatim.git/blob - lib-sql/indices_updates.src.sql
Merge pull request #2192 from lonvia/database-versioning
[nominatim.git] / lib-sql / indices_updates.src.sql
1 -- Indices used only during search and update.
2 -- These indices are created only after the indexing process is done.
3
4 CREATE INDEX CONCURRENTLY idx_placex_pendingsector ON placex USING BTREE (rank_address,geometry_sector) {ts:address-index} where indexed_status > 0;
5
6 CREATE INDEX CONCURRENTLY idx_location_area_country_place_id ON location_area_country USING BTREE (place_id) {ts:address-index};
7
8 DROP INDEX CONCURRENTLY IF EXISTS place_id_idx;
9 CREATE UNIQUE INDEX CONCURRENTLY idx_place_osm_unique on place using btree(osm_id,osm_type,class,type) {ts:address-index};