[postgis-users] Speeding up geocoding on bigger states

[BladeOfLight16]

On Wed, Aug 28, 2013 at 11:25 PM, Tom C <tom at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130829/fb817fac/attachment.html>