[postgis-devel] [PostGIS] #1382: Some addresses take a long time to geocode or normalize

[PostGIS]

#1382: Some addresses take a long time to geocode or normalize
----------------------------+-----------------------------------------------
 Reporter:  raviada         |       Owner:  robe         
     Type:  defect          |      Status:  assigned     
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by raviada):

 Regina, I upgraded to the new build which is Revision 8450. the output
 from postgis_full_version is "POSTGIS="2.0.0SVN" GEOS="3.2.2-CAPI-1.6.2"
 PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.8" USE_STATS"

 Also I see --$Id: normalize_address.sql 8252 2011-11-29 08:49:06Z robe $-
 in normalize_address function.

 select geocode('2601 24TH AVE, ASTORIA, NY 111022337'); returns two rows
 Total query runtime: 20943 ms.
 2 rows retrieved.

 "("(,,24th,Ave,,,""New
 York"",NY,11204,t)",0101000020AD10000036CF279D807E52C0511C69D0424E4440,21)"
 "("(,,24th,Ave,,,""New
 York"",NY,11214,t)",0101000020AD100000FA12A7B3417F52C0699E6C55CF4C4440,21)"

 I think it is still a problem in using the geocode function. normalize
 function is now returning real fast, in 30-60 ms. Geococe is the one
 taking 20 secs. All NY addresses are like this.

 Thanks
 Ravi Ada

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1382#comment:6>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.