From: Sarah Hoffmann Date: Tue, 17 Oct 2023 08:59:47 +0000 (+0200) Subject: convert sqlite: add index on parent_place_id X-Git-Tag: v4.4.0~87^2~1 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/84d6b481ae58bf3e998959eb74639e24e99341ea convert sqlite: add index on parent_place_id --- diff --git a/nominatim/tools/convert_sqlite.py b/nominatim/tools/convert_sqlite.py index afae0d6b..d766c642 100644 --- a/nominatim/tools/convert_sqlite.py +++ b/nominatim/tools/convert_sqlite.py @@ -113,6 +113,7 @@ class SqliteWriter: await self.create_spatial_index('osmline', 'linegeo') await self.create_spatial_index('tiger', 'linegeo') await self.create_index('placex', 'place_id') + await self.create_index('placex', 'parent_place_id') await self.create_index('placex', 'rank_address') await self.create_index('addressline', 'place_id')