X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/53c526c01d145ca27bc3bea298305e483272eb29..9e35e5c2b02887e361972ffbb20e65bbba0d02c7:/sql/partition-tables.src.sql diff --git a/sql/partition-tables.src.sql b/sql/partition-tables.src.sql index 61ed5281..20dafcd7 100644 --- a/sql/partition-tables.src.sql +++ b/sql/partition-tables.src.sql @@ -48,6 +48,7 @@ CREATE INDEX idx_search_name_-partition-_place_id ON search_name_-partition- USI CREATE INDEX idx_search_name_-partition-_centroid ON search_name_-partition- USING GIST (centroid) {ts:address-index}; CREATE INDEX idx_search_name_-partition-_name_vector ON search_name_-partition- USING GIN (name_vector) WITH (fastupdate = off) {ts:address-index}; +DROP TABLE IF EXISTS location_road_-partition-; CREATE TABLE location_road_-partition- ( place_id BIGINT, partition SMALLINT,