On Wed, Aug 28, 2013 at 10:54 PM, BladeOfLight16 <[email protected]>wrote:
> On Wed, Aug 28, 2013 at 11:25 PM, Tom C <[email protected]> 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. > > Considering that VACUUM FULL has already been run, just ANALYZE will probably get as good of results as VACUUM FULL ANALYZE, and should run more quickly. -Eric
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
