[postgis-users] Speeding up geocoding on bigger states

Tom C tom at tecrails.com
Wed Aug 28 20:25:30 PDT 2013


I have set up the Tiger geocoder for all US states and territories, but
when I try to geocode addresses in larger states like CA and TX the
processing takes quite a long time. I have run SELECT
install_missing_indexes(); and VACUUM FULL; on the database and yet I was
able to write this email before I could geocode an address in TX. Any tips
or commands that I can run to speed things up?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130828/f7e2b415/attachment.html>


More information about the postgis-users mailing list