From 40bc1752c26635ffd05dbb6113cb4ff6775f420a Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Wed, 30 Sep 2020 09:21:35 +0200 Subject: [PATCH] remove unused idx_placex_geometry_reverse_lookupPoint The index has been unused ever since the query using it was changed two years ago. Given that it has not been missed much, drop it completely here. --- sql/indices.src.sql | 5 ----- 1 file changed, 5 deletions(-) diff --git a/sql/indices.src.sql b/sql/indices.src.sql index fa009783..7fcd965f 100644 --- a/sql/indices.src.sql +++ b/sql/indices.src.sql @@ -10,11 +10,6 @@ CREATE INDEX idx_placex_rank_search ON placex USING BTREE (rank_search) {ts:sear CREATE INDEX idx_placex_rank_address ON placex USING BTREE (rank_address) {ts:search-index}; CREATE INDEX idx_placex_parent_place_id ON placex USING BTREE (parent_place_id) {ts:search-index} where parent_place_id IS NOT NULL; -CREATE INDEX idx_placex_geometry_reverse_lookupPoint - ON placex USING gist (geometry) {ts:search-index} - WHERE (name is not null or housenumber is not null or rank_address between 26 and 27) - AND class not in ('railway','tunnel','bridge','man_made') - AND rank_address >= 26 AND indexed_status = 0 AND linked_place_id is null; CREATE INDEX idx_placex_geometry_reverse_lookupPolygon ON placex USING gist (geometry) {ts:search-index} WHERE St_GeometryType(geometry) in ('ST_Polygon', 'ST_MultiPolygon') -- 2.39.5