From 57facc47672d84d1dbf87cecb31bb91104b24dfb Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Thu, 14 Feb 2013 00:40:58 +0100 Subject: [PATCH 1/1] Revert "increase search radius for named roads" This reverts commit c2d5303192c960b456b2d2ab4b6e14cead2042ac. It causes serious performance problems in densely mapped areas. --- sql/partition-functions.src.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 -- 2.39.5