[postgis-users] Tigerdata for AZ, AS and VI

[Ravi ada]

In these examples, they used only 2GB memory and 3GHz machine but still
achieved a blazing fast results. The same queries mentioned in the link
taking 10 and even 100 times more time to query a particular address. I am
using a 16GB, 6 Core AMD machine, dedicated to this process. I did the
tuning on postgresql config file based on the recommendations. I am
attaching my file here.. Please let me know if the tuning parameters look
good.
http://postgis.refractions.net/documentation/manual-svn/Geocode.html

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;

Thanks
Ravi Ada

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Ravi ada
Sent: Monday, December 12, 2011 7:05 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Tigerdata for AZ, AS and VI

Thank you Steve. I downloaded AZ files again and loaded fine but others are
still the same problem. According to your explanation that should be ok.

I got the postgis database loaded for all states now. I have about 3 mil
addresses, may not all be normalized, which I am trying to batch geocode
them. I am using the example mentioned in this link.
http://www.postgresonline.com/journal/archives/181-pgscript_intro.html

I am even using 100 as a batch, my update query is too slow. Its updating at
1500 per hour. That's too slow, I will never be able to finish them. 

I have 16GB RAM, and 7200 rpm disk partitioned to hold the postgres table
spaces. I am not sure what makes it run faster. Anybody has done so many
addresses before? What makes the performance go faster? I am attaching the
query and query plan here. www.pastie.org/3008194

Any help is appreciated.

Thanks
Ravi Ada

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Stephen
Woodbridge
Sent: Monday, December 12, 2011 8:50 AM
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] Tigerdata for AZ, AS and VI

On 12/12/2011 9:18 AM, Ravi ada wrote:
> Hello All,
>
> Has anyone experienced loading tigerdata into postgis database for 
> Arizona, American Samoa and Virgin Islands. I getting "*addr.dbf"
> cannot find errors. All the other states are loaded fine. I tried to 
> download the shape files again thinking that they might have been 
> corrupted during the transmission, but even after that I am getting 
> the
same error.
>
> Any ideas?

My download of Tiger has all the *addr* files for Arizona and I believe I
have accessed them all without a problem.


In general, the *addr* files are optional, and there are none for Guam,
American Samoa and Virgin Islands.

Typically if the county or county equivalent does not have roads with
address ranges in it, then it will not have any *addr* files. So it is
possible that a county in Arizona in say the desert might not have any
address ranges and therefore not have that file, but looking at the list of
counties in Arizona it looks like they all have those files.

-Steve W
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgresql.conf
Type: application/octet-stream
Size: 19236 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111212/48982fd0/attachment.obj>