X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/53c526c01d145ca27bc3bea298305e483272eb29..71ae7f10f74251ebef13abe8d186276e6255b5d4:/sql/partition-tables.src.sql?ds=inline 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,