[postgis-users] Batch geocoding (~2 mil addresses)

[Andy Colson]

On 11/29/2011 11:18 PM, Ravi ada wrote:
> Hello All,
>
> I have been fighting with PostGIS for the last week or two to geocode
> about 2 million addresses. Here are the challenges that I am facing.
>
> 1)I sorted the addresses by zip, address, city to group the similar
> addresses together.
>
> 2)So far I have seen only 50% of rating zero, that means perfect match.
>
> 3)Some addresses have Suite# or Apt# in address line 1. Geocode function
> takes longer time for such addresses
>
> 4)Addresses that are on the interstate, may be on the service road.
> These are taking longer to code.

How about posting an "EXPLAIN ANALYZE" to http://explain.depesz.com/. 
Maybe we can speed it up.

-Andy