[postgis-users] Speeding up geocoding on bigger states

[Eric McKeeth]

On Wed, Aug 28, 2013 at 10:54 PM, BladeOfLight16
<bladeoflight16 at gmail.com>wrote:

> 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.
>
>
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130829/394aaca2/attachment.html>