<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.17183"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>Brandon,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>BTW: I recently uploaded PostGIS 2.1.5 on stackbuilder for 9.3
and 9.4 (still need to do for 9.2) and I have made some fixes
between 2.1.3 and 2.1.5 of the geocoder so might be worthwhile upgrading.
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>To upgrade doing a :</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>ALTER EXTENSION postgis_tiger_geocoder UPDATE TO
"2.1.5";<BR></FONT></SPAN></DIV></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>Couple of questions</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>1) Did you run the nation script? That is often the cause of
this kind of issue if that was not done before loading
states</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>2) Which area are you running?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>3) How many states do yo have loaded? I can try to
test out myself to see if I can replicate the issue you are
having.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>4) Are you running on 32-bit windows 7 or 64-bit
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014></SPAN><SPAN
class=013000604-22122014><FONT color=#0000ff size=2 face=Arial>5) What is
your PostgreSQL shared_buffers set to in
postgresql.conf?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>6) What is the exact version of PostgreSQL 9.3 you are
running: SELECT version();</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>mine returns: PostgreSQL 9.3.5, compiled by Visual C++ build
1600, 64-bit</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial> </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014></SPAN><SPAN
class=013000604-22122014><FONT color=#0000ff size=2
face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial>PostGIS PSC member and Windows PostGIS package
maintainer</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial><A
href="http://postgis.net">http://postgis.net</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=013000604-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Brandon
Abear<BR><B>Sent:</B> Sunday, December 21, 2014 10:21 PM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> [postgis-users] Poor Geocoder
Performance<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr><SPAN style="FONT-SIZE: 13px">I recently installed PostGIS 2.1.3 on
a local PostgreSQL instance (9.3). I imported the countrywide TIGER data set,
installed the missing indexes, and ran a vacuum analyze on everything.</SPAN><BR
style="FONT-SIZE: 13px"><BR style="FONT-SIZE: 13px"><SPAN
style="FONT-SIZE: 13px">The geocoder is significantly slower than what is
reported in the documentation (</SPAN><A style="FONT-SIZE: 13px"
href="http://postgis.net/docs/Geocode.html"
target=_blank>http://postgis.net/docs/Geocode.html</A><SPAN
style="FONT-SIZE: 13px">). The example takes roughly 4 seconds to return a
result while the documentation shows ~61ms. There are other addresses which take
nearly a minute to geocode. I ran through a batch of 500 addresses to test, and
only a handful returned a rating under 20. I am running on Windows 7.</SPAN>
<DIV style="FONT-SIZE: 13px"><BR clear=all>
<DIV>I have looked through as many similar issues online as I could find. I also
changed some of the config settings such as shared_buffer, but the performance
increase was negligible. I am out of ideas. Has anyone run into a similar issue
and found a solution?</DIV>
<DIV><BR></DIV>
<DIV>Thank you for your time!</DIV></DIV>
<DIV><BR></DIV>-- <BR>
<DIV class=gmail_signature><B><FONT size=4>Brandon M. Abear</FONT></B>
<DIV><I>Carthage College, 2013</I></DIV>
<DIV><FONT color=#666666>Cell: (847) 848-3907</FONT></DIV>
<DIV><FONT color=#666666><A href="mailto:babear@carthage.edu"
target=_blank>babear@carthage.edu</A></FONT></DIV></DIV></DIV></BODY></HTML>