Thanks all for the suggestions. I am migrating this process to a bigger machine which has 16GB RAM and faster hard drives. I will incorporate these changes once the migration completes.
There are two things I got so far I need to do. 1) use pgScript to commit every 500 or 1000 updates 2) send explain analyze to http://explain.depesz.com/ further evaluate the query plan I will keep you posted guys.. Thanks Ravi Ada -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Andy Colson Sent: Wednesday, November 30, 2011 8:54 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] Batch geocoding (~2 mil addresses) 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
