From: Channgping Chen <changping.chen@samsara.com>
Date: Mon, 19 Apr 2021 00:01:01 +0000 (+0000)
Subject: fix index on location_property_tiger (parent_place_id)
X-Git-Tag: v4.0.0~110^2
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/29a314a092972e82cb0014499f60959d3f2909a4?hp=29a314a092972e82cb0014499f60959d3f2909a4

fix index on location_property_tiger (parent_place_id)

Looks like 2af82975cd968ec09683ae5b16a9aa157a7f2176
accidentally renamed an index. Because of the added "if not
exists" clause, the index doesn't get created. This
significantly slows down reverse queries because they now
require full scans on location_property_tiger.

Without this fix, reverse queries can take 8s on a full
planet install on an r5.8xlarge instance in EC2.
---