[postgis-devel] [PostGIS] #1145: Some addresses are very slow to Geocode

[PostGIS]

#1145: Some addresses are very slow to Geocode
----------------------------+-----------------------------------------------
 Reporter:  mikepease       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  high            |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by robe):

 I took a cursory glance at one.  Only issue I see is the tiger zip is
 different than that of the addresss.  For me the samples I've run above
 take 23-72 seconds.  So still much much longer than others, but not quite
 as long as yours.  If I do the geocode with limit 1 it reduces down to
 about 20 seconds.

 What do you get if you use the geocode(address,1)   option?

 I still haven't released my recent changes, so I'm not really working with
 the same build you are testing against so timings are hard to compare.
 I'm still fiddling with issues that the geocoder is not using the edge
 indexes much and that is making sthings much slower than they should be.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1145#comment:3>
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.