X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/dc7cfd1708da6fceb268d2efaaf92ef513a20234..14cc047cf4e8e2028be9c34cb6b79ef20816b532:/lib-sql/indices.sql?ds=inline diff --git a/lib-sql/indices.sql b/lib-sql/indices.sql index 9c31f556..4d92452d 100644 --- a/lib-sql/indices.sql +++ b/lib-sql/indices.sql @@ -31,6 +31,7 @@ CREATE INDEX IF NOT EXISTS idx_placex_geometry ON placex -- Index is needed during import but can be dropped as soon as a full -- geometry index is in place. The partial index is almost as big as the full -- index. +--- DROP INDEX IF EXISTS idx_placex_geometry_lower_rank_ways; --- CREATE INDEX IF NOT EXISTS idx_placex_geometry_reverse_lookupPolygon @@ -60,7 +61,6 @@ CREATE INDEX IF NOT EXISTS idx_postcode_postcode --- DROP INDEX IF EXISTS idx_placex_geometry_address_area_candidates; DROP INDEX IF EXISTS idx_placex_geometry_buildings; - DROP INDEX IF EXISTS idx_placex_geometry_lower_rank_ways; DROP INDEX IF EXISTS idx_placex_wikidata; DROP INDEX IF EXISTS idx_placex_rank_address_sector; DROP INDEX IF EXISTS idx_placex_rank_boundaries_sector; @@ -81,6 +81,9 @@ CREATE INDEX IF NOT EXISTS idx_postcode_postcode type TEXT, deferred BOOLEAN ); +--- + CREATE INDEX IF NOT EXISTS idx_location_postcode_parent_place_id + ON location_postcode USING BTREE (parent_place_id) {{db.tablespace.address_index}}; {% endif %} -- Indices only needed for search.