use address counts for improving index lookup

[nominatim.git] / nominatim / api / search / db_searches.py

diff --git a/nominatim/api/search/db_searches.py b/nominatim/api/search/db_searches.py
index 5a13061e091074c87b2fc9aa51c78ab4abeb9354..3f294de7c925ba5b2017bfd247496ef2c28c189c 100644 (file)
--- a/nominatim/api/search/db_searches.py
+++ b/nominatim/api/search/db_searches.py
@@ -610,6 +610,10 @@ class PostcodeSearch(AbstractSearch):
                              .where(p.c.country_code == row.country_code)\
                              .where(p.c.postcode == row.postcode)\
                              .limit(1)
                              .where(p.c.country_code == row.country_code)\
                              .where(p.c.postcode == row.postcode)\
                              .limit(1)

+
+            if details.geometry_output:
+                placex_sql = _add_geometry_columns(placex_sql, p.c.geometry, details)
+

             for prow in await conn.execute(placex_sql, _details_to_bind_params(details)):
                 result = nres.create_from_placex_row(prow, nres.SearchResult)
                 break
             for prow in await conn.execute(placex_sql, _details_to_bind_params(details)):
                 result = nres.create_from_placex_row(prow, nres.SearchResult)
                 break