<!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=275404104-22122014><FONT color=#0000ff
size=2 face=Arial>Brandon,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=275404104-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=275404104-22122014><FONT color=#0000ff
size=2 face=Arial>For 64-bit 256mb is a little low. I would up that to at
least a gigabyte if you can spare it. What processor are you running?
and how much motherboard ram do you have?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=275404104-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=275404104-22122014><FONT color=#0000ff
size=2 face=Arial>Most of my work (particularly on windows) is regional so never
had to load more than 5 or so states. So it's possible that is an issue. I
think Darkblue_b (Brian Hamlin, wave if you are reading) has done much larger
datasets so he might have a better idea. Then again I think he runs on
beefed up hardware with 16 cores and lots of RAM.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=275404104-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=275404104-22122014><FONT color=#0000ff
size=2 face=Arial>If you can send me a sample address that would help. Can
send me off list if sensitive information.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=275404104-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=275404104-22122014><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=275404104-22122014><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=275404104-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=275404104-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 11:30 PM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> Re: [postgis-users] Poor Geocoder
Performance<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>Hi Regina,<BR><BR>I will check out the update that you have
uploaded.<BR><BR>To answer your questions:<BR>1) Yep, I ran the nation script
before running the subsequent state scripts.<BR>2) The test batch includes
addresses in all of the continental states. If I am able to get the geocoder to
run quickly enough, I will be geocoding millions of addresses.<BR>3) I have all
states loaded.<BR>4) Windows 7 64-bit<BR>5) PostgreSQL shared_buffer is 256mb
<DIV>6) I am running the same version as you.</DIV></DIV>
<DIV class=gmail_extra><BR>
<DIV class=gmail_quote>On Sun, Dec 21, 2014 at 10:16 PM, Paragon Corporation
<SPAN dir=ltr><<A href="mailto:lr@pcorp.us"
target=_blank>lr@pcorp.us</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><U></U>
<DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial>Brandon,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff 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><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff face=Arial>To upgrade doing
a :</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff face=Arial>ALTER EXTENSION
postgis_tiger_geocoder UPDATE TO "2.1.5";<BR></FONT></SPAN></DIV></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff face=Arial>Couple of
questions</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff 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><FONT color=#0000ff face=Arial>2) Which area are
you running?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff 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><FONT color=#0000ff face=Arial>4) Are you
running on 32-bit windows 7 or 64-bit </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN></SPAN><SPAN><FONT color=#0000ff face=Arial>5)
What is your PostgreSQL shared_buffers set to in
postgresql.conf?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff 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><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff 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><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN></SPAN><SPAN><FONT color=#0000ff
face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff face=Arial>PostGIS PSC
member and Windows PostGIS package maintainer</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff face=Arial><A
href="http://www.postgis.us"
target=_blank>http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff face=Arial><A
href="http://postgis.net"
target=_blank>http://postgis.net</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV><BR>
<DIV lang=en-us dir=ltr align=left>
<HR>
<FONT face=Tahoma><B>From:</B> <A
href="mailto:postgis-users-bounces@lists.osgeo.org"
target=_blank>postgis-users-bounces@lists.osgeo.org</A> [mailto:<A
href="mailto:postgis-users-bounces@lists.osgeo.org"
target=_blank>postgis-users-bounces@lists.osgeo.org</A>] <B>On Behalf Of
</B>Brandon Abear<BR><B>Sent:</B> Sunday, December 21, 2014 10:21
PM<BR><B>To:</B> <A href="mailto:postgis-users@lists.osgeo.org"
target=_blank>postgis-users@lists.osgeo.org</A><BR><B>Subject:</B>
[postgis-users] Poor Geocoder Performance<BR></FONT><BR></DIV>
<DIV>
<DIV class=h5>
<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><B><FONT size=4>Brandon M. Abear</FONT></B>
<DIV><I>Carthage College, 2013</I></DIV>
<DIV><FONT color=#666666>Cell: <A href="tel:%28847%29%20848-3907"
target=_blank value="+18478483907">(847) 848-3907</A></FONT></DIV>
<DIV><FONT color=#666666><A href="mailto:babear@carthage.edu"
target=_blank>babear@carthage.edu</A></FONT></DIV></DIV></DIV></DIV></DIV></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</A><BR><A
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users"
target=_blank>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</A><BR></BLOCKQUOTE></DIV><BR><BR
clear=all>
<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>