<!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=969172411-22122014><FONT color=#0000ff
size=2 face=Arial>Brandon,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial>Hmm weird is this a new street? I should load up tiger
2014 data to see if a difference. (PostGIS 2.1 has tiger 2013 load-- 2014
loader is in PostGIS 2.2)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial>I was using 2013 data and it gives me a bad answer, but
inspecting the edges data, I see no EADS listed in Chicago
area.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial>select pprint_addy(addy), rating from geocode('7 EADS ST,
CHICAGO, IL 60632',3);</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial>I get these answers in about 150ms (but like I said I only
have a few states loaded and my shared buffers is set to
2GB)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial>Eads St, Benton, IL 62812;20<BR>7 Edds St, Pekin, IL
61554;21<BR>W Eads St, Urbana, IL 61801;22<BR></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial>I looked up the same search on Google maps which seemed also
wrong</FONT></SPAN><SPAN class=969172411-22122014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=969172411-22122014>
<H1 class="cards-entity-title cards-strong cards-text-truncate-and-wrap"
jstcache="0"><SPAN jstcache="416">Kopka Pinkus Dolin & Eads</SPAN></H1>
<DIV class="cards-entity-address cards-strong" jstcache="419">
<DIV class=cards-text-truncate-and-wrap jstcache="420" jsinstance="0"><SPAN
jstcache="421">200 North LaSalle Street #2850</SPAN></DIV>
<DIV class=cards-text-truncate-and-wrap jstcache="420" jsinstance="*1"><SPAN
jstcache="421">Chicago, IL 60601</SPAN></DIV></DIV></SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><SPAN class=969172411-22122014></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>H<SPAN class=969172411-22122014>ave another address I
can experiment with.</SPAN></FONT></FONT></FONT><BR></DIV>
<DIV><SPAN class=969172411-22122014><FONT color=#0000ff size=2
face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=969172411-22122014><FONT color=#0000ff size=2
face=Arial>Regina</FONT></SPAN></DIV>
<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> Monday, December 22, 2014 12:13 AM<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>Here is a sample address. This one currently takes 30567ms to
return.<BR>7 EADS ST, CHICAGO, IL 60632<BR><BR>
<DIV>My desktop has 16GB of ram and an i7 processor.<BR><BR></DIV></DIV>
<DIV class=gmail_extra><BR>
<DIV class=gmail_quote>On Sun, Dec 21, 2014 at 10:52 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><FONT color=#0000ff 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><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff 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><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff 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><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><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></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><SPAN><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></SPAN><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 class=h5>
<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>
<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"
target=_blank>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><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>