X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/ff1c78fef5d64b1b0b7eba96332caffb46bc3e21..f5cbe0e6babf9b4649eb2e00717d21474052b08e:/sql/indices_search.src.sql?ds=sidebyside

diff --git a/sql/indices_search.src.sql b/sql/indices_search.src.sql
index 70cd8799..d1363fc6 100644
--- a/sql/indices_search.src.sql
+++ b/sql/indices_search.src.sql
@@ -1,6 +1,6 @@
 -- Indices used for /search API.
 -- These indices are created only after the indexing process is done.
 
-CREATE INDEX CONCURRENTLY idx_search_name_nameaddress_vector ON search_name USING GIN (nameaddress_vector) WITH (fastupdate = off) {ts:search-index};
-CREATE INDEX CONCURRENTLY idx_search_name_name_vector ON search_name USING GIN (name_vector) WITH (fastupdate = off) {ts:search-index};
-CREATE INDEX CONCURRENTLY idx_search_name_centroid ON search_name USING GIST (centroid) {ts:search-index};
+CREATE INDEX idx_search_name_nameaddress_vector ON search_name USING GIN (nameaddress_vector) WITH (fastupdate = off) {ts:search-index};
+CREATE INDEX idx_search_name_name_vector ON search_name USING GIN (name_vector) WITH (fastupdate = off) {ts:search-index};
+CREATE INDEX idx_search_name_centroid ON search_name USING GIST (centroid) {ts:search-index};