From f7b8e2c64042f7c66c090058289ecc4f80bc54fc Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Thu, 20 Sep 2012 13:32:14 +0000 Subject: [PATCH] #1991: speed issue with 9.2 on geocode and geocoder_intersection, seems to be 10-50 times faster by forcing join_collapse limit = 2 git-svn-id: http://svn.osgeo.org/postgis/trunk@10310 b70326c6-7e19-0410-871a-916f4a2858ee --- extras/tiger_geocoder/tiger_2011/geocode/geocode_address.sql | 3 +-- .../tiger_geocoder/tiger_2011/geocode/geocode_intersection.sql | 1 + 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/extras/tiger_geocoder/tiger_2011/geocode/geocode_address.sql b/extras/tiger_geocoder/tiger_2011/geocode/geocode_address.sql index 6f98f3a85..1e74da877 100644 --- a/extras/tiger_geocoder/tiger_2011/geocode/geocode_address.sql +++ b/extras/tiger_geocoder/tiger_2011/geocode/geocode_address.sql @@ -433,6 +433,5 @@ BEGIN END; $$ LANGUAGE 'plpgsql' STABLE COST 1000 ROWS 50; ---ALTER FUNCTION geocode_address(IN norm_addy, IN integer , IN geometry) SET enable_mergejoin='off'; - +ALTER FUNCTION geocode_address(IN norm_addy, IN integer, IN geometry) SET join_collapse_limit='2'; diff --git a/extras/tiger_geocoder/tiger_2011/geocode/geocode_intersection.sql b/extras/tiger_geocoder/tiger_2011/geocode/geocode_intersection.sql index 838c76e61..8a9448915 100644 --- a/extras/tiger_geocoder/tiger_2011/geocode/geocode_intersection.sql +++ b/extras/tiger_geocoder/tiger_2011/geocode/geocode_intersection.sql @@ -146,3 +146,4 @@ $$ LANGUAGE plpgsql IMMUTABLE COST 1000 ROWS 10; +ALTER FUNCTION geocode_intersection(IN text, IN text, IN text, IN text, IN text, IN integer) SET join_collapse_limit='2'; -- 2.40.0