From 85d65a2fd27cc5bc47685e7759a1895e1f9f2236 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Fri, 18 Feb 2022 11:11:22 +0100 Subject: [PATCH] create idx_place_interpolations for import already It is needed to look up if a node is part of an interpolation. Fixes #2608. --- lib-sql/indices.sql | 4 ---- lib-sql/tables.sql | 5 +++++ 2 files changed, 5 insertions(+), 4 deletions(-) diff --git a/lib-sql/indices.sql b/lib-sql/indices.sql index ad6753c6..332cbb00 100644 --- a/lib-sql/indices.sql +++ b/lib-sql/indices.sql @@ -49,10 +49,6 @@ CREATE INDEX IF NOT EXISTS idx_postcode_postcode CREATE UNIQUE INDEX IF NOT EXISTS idx_place_osm_unique ON place USING btree(osm_id, osm_type, class, type) {{db.tablespace.address_index}}; - - CREATE INDEX IF NOT EXISTS idx_place_interpolations - ON place USING gist(geometry) {{db.tablespace.address_index}} - WHERE osm_type = 'W' and address ? 'interpolation'; {% endif %} -- Indices only needed for search. diff --git a/lib-sql/tables.sql b/lib-sql/tables.sql index f554c58f..538286b8 100644 --- a/lib-sql/tables.sql +++ b/lib-sql/tables.sql @@ -256,4 +256,9 @@ ALTER TABLE ONLY wikipedia_redirect ADD CONSTRAINT wikipedia_redirect_pkey PRIMA -- Add one for lookup of associated street relations. CREATE INDEX planet_osm_rels_parts_associated_idx ON planet_osm_rels USING gin(parts) WHERE tags @> ARRAY['associatedStreet']; +-- Needed for lookups if a node is part of an interpolation. +CREATE INDEX IF NOT EXISTS idx_place_interpolations + ON place USING gist(geometry) {{db.tablespace.address_index}} + WHERE osm_type = 'W' and address ? 'interpolation'; + GRANT SELECT ON table country_osm_grid to "{{config.DATABASE_WEBUSER}}"; -- 2.39.5