On Wed, Aug 28, 2013 at 11:25 PM, Tom C <t...@tecrails.com> wrote: > 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? >
VACUUM FULL; will not collect statistics. Try VACUUM FULL ANALYZE;. If that doesn't help, try examining the EXPLAIN ANALYZE for trouble (bad estimates, not using indexes). You could provide the query and the EXPLAIN ANALYZE here if you can't find the problem.
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users