X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/2c8242c8dfccb74861eb599ecc1064e764bdec99..44d5148e5fb203ec88fbf56433a6cb93c4b1d209:/lib-sql/tiger_import_finish.sql diff --git a/lib-sql/tiger_import_finish.sql b/lib-sql/tiger_import_finish.sql index 1a9dc2dd..c02ce2a3 100644 --- a/lib-sql/tiger_import_finish.sql +++ b/lib-sql/tiger_import_finish.sql @@ -1,6 +1,17 @@ +-- SPDX-License-Identifier: GPL-2.0-only +-- +-- This file is part of Nominatim. (https://nominatim.org) +-- +-- Copyright (C) 2022 by the Nominatim developer community. +-- For a full list of authors see the git log. + --index only on parent_place_id CREATE INDEX IF NOT EXISTS idx_location_property_tiger_parent_place_id_imp - ON location_property_tiger_import (parent_place_id) {{db.tablespace.aux_index}}; + ON location_property_tiger_import (parent_place_id) +{% if postgres.has_index_non_key_column %} + INCLUDE (startnumber, endnumber, step) +{% endif %} + {{db.tablespace.aux_index}}; CREATE UNIQUE INDEX IF NOT EXISTS idx_location_property_tiger_place_id_imp ON location_property_tiger_import (place_id) {{db.tablespace.aux_index}};