[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Speeding up geocoding on bigger states
From:       Eric McKeeth <eldin00 () gmail ! com>
Date:       2013-08-29 7:36:48
Message-ID: CAF=gRfzgcQFw7j_xcaZFQAmXkkQmLmiBQM2Lzb8GYi4=RGQrOA () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


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

> On Wed, Aug 28, 2013 at 11:25 PM, Tom C <tom@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

[Attachment #5 (text/html)]

<div dir="ltr"><div><div class="gmail_extra"><div class="gmail_quote">On Wed, Aug 28, \
2013 at 10:54 PM, BladeOfLight16 <span dir="ltr">&lt;<a \
href="mailto:bladeoflight16@gmail.com" \
target="_blank">bladeoflight16@gmail.com</a>&gt;</span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div \
class="gmail_quote"><div class="im">On Wed, Aug 28, 2013 at 11:25 PM, Tom C <span \
dir="ltr">&lt;<a href="mailto:tom@tecrails.com" \
target="_blank">tom@tecrails.com</a>&gt;</span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">

<div dir="ltr">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?</div>


</blockquote></div><div><br>VACUUM FULL; will not collect statistics. Try VACUUM FULL \
ANALYZE;. If  that doesn&#39;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&#39;t find the problem.<br></div></div></div></div>
<br></blockquote></div><br></div><div class="gmail_extra">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.<br><br></div> <div \
class="gmail_extra">-Eric<br></div></div></div>



_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]