From: Sarah Hoffmann <lonvia@denofr.de>
Date: Wed, 13 Feb 2013 23:40:58 +0000 (+0100)
Subject: Revert "increase search radius for named roads"
X-Git-Tag: v2.2.0~116
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/57facc47672d84d1dbf87cecb31bb91104b24dfb?hp=705bcf80fbb35cea677f1a788aa81ab44fa9f6ab

Revert "increase search radius for named roads"

This reverts commit c2d5303192c960b456b2d2ab4b6e14cead2042ac.
It causes serious performance problems in densely mapped areas.
---

diff --git a/sql/partition-functions.src.sql b/sql/partition-functions.src.sql
index 6afbbdda..0e26849d 100644
--- a/sql/partition-functions.src.sql
+++ b/sql/partition-functions.src.sql
@@ -124,7 +124,7 @@ BEGIN
           ST_Distance(centroid, point) as distance, null as isguess
           FROM search_name_-partition-
           WHERE name_vector @> ARRAY[isin_token]
-          AND ST_DWithin(centroid, point, 0.03)
+          AND ST_DWithin(centroid, point, 0.01) 
           AND search_rank between 22 and 27
       ORDER BY distance ASC limit 1
     LOOP