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

Andy Colson andy at squeakycode.net
Tue Dec 13 06:43:56 PST 2011


On 12/12/2011 11:08 PM, Ravi ada wrote:
> Hello Regina,
>
> I was able to load the data for all states, now I have to gocode about 2
> mil addresses . I followed the link below and used the pgScript option
> to batch 100 addresses. I am having a terrible performance, query return
> time is 10 to 100 times more than the bench marks.
>
> _This query is supposed to take only (61ms) but on my machine is was
> (734ms)._
>
> SELECT g.rating, ST_X(g.geomout) As lon, ST_Y(g.geomout) As lat,
>
> (addy).address As stno, (addy).streetname As street,
>
> (addy).streettypeabbrev As styp, (addy).location As city,
> (addy).stateabbrev As st,(addy).zip
>
> FROM geocode('75 State Street, Boston MA 02109') As g;
>
> I am running this on a machine which has 16GB RAM and 6 cores AMD
> processor. Something is missing to cause this hang up. please direct me
> to right direction. I am looking for help.
>
> Thanks
>
> Ravi Ada
>

Cant help, need info.

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

6 Cores is only going to run slower, MHz wise, the only way to benefit 
from it is to run 6 concurrent processes.

How do you know the query is "supposed" to take 61ms?

-Andy



More information about the postgis-users mailing list