From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sat, 8 Jul 2023 14:28:51 +0000 (+0200)
Subject: use constant expressions to select partial indexes in reverse
X-Git-Tag: v4.3.0~55^2~2
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/75139961a3bdcb3b70381ffd10f58fd316fd9f26?hp=75139961a3bdcb3b70381ffd10f58fd316fd9f26

use constant expressions to select partial indexes in reverse

When expressions are generated with SQLAlchemy, any constants are
replaced with bind parameters. The bind parameters become parameters of
prepared statements. The result is that the query planner tends to
oversee that the partial indexes can be used.
---