<!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 8.00.7601.17573"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=075211421-28052011><FONT color=#0000ff
size=2 face=Arial>Mikal,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=075211421-28052011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=075211421-28052011><FONT color=#0000ff
size=2 face=Arial>Can you send me the change you made and the indexes you
added. When adding some more data, I realized I had hardcoded an index for
our local state (MA) and I know without that index that that particular query
does run pretty slow. So just wondering if its along the same
lines.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=075211421-28052011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=075211421-28052011><FONT color=#0000ff
size=2 face=Arial>I've also fixed I think all the issues with running the loader
on Unix/Linux -- well at least I was able to get it to run on my
CentOS. Thanks to all who contributed input to that. I took bits and
pieces from many people's comments but couldn't apply a full diff from anyones
since I had already changed the code too much to safely apply any of those
patches.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=075211421-28052011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=075211421-28052011><FONT color=#0000ff
size=2 face=Arial>How many states do you have loaded BTW? I just have CA
loaded on my CentOS -- which is an 8GB/8 core cloud server. I'm getting
around 38ms - 450ms per test, but I have yet to load the other
states.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=075211421-28052011><FONT color=#0000ff
size=2 face=Arial>It also seems to cache very well so that if I geocode an
address on the same street (not necessarily same address), the first call might
take 450ms and the second 38ms. I suspect this might be because I also
marked a good chunk of the functions STABLE or IMMUTABLE.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=075211421-28052011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=075211421-28052011><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=075211421-28052011><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=075211421-28052011><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=075211421-28052011></SPAN> </DIV><FONT
color=#0000ff size=2 face=Arial></FONT><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Mikal
Laster<BR><B>Sent:</B> Friday, May 27, 2011 8:18 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] Fw: re:
Geocoder (from extras)<BR></FONT><BR></DIV>
<DIV></DIV>
<TABLE border=0 cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD vAlign=top><BR><BR>--- On <B>Fri, 5/27/11, Mikal Laster
<I><orcltek@yahoo.com></I></B> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(16,16,255) 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px"><BR>From:
Mikal Laster <orcltek@yahoo.com><BR>Subject: re:[postgis-users]
Geocoder (from extras)<BR>To:
postgis-users@postgis.refractions.net<BR>Date: Friday, May 27, 2011,
7:22 AM<BR><BR>
<DIV id=yiv1881146453>
<TABLE border=0 cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD vAlign=top>
<DIV id=yiv1881146453>
<TABLE id=yiv1881146453bodyDrftID class=yiv1881146453 border=0
cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD
style="FONT-FAMILY: arial; FONT-SIZE: 10pt; font-size-adjust: inherit; font-stretch: inherit"
id=yiv1881146453drftMsgContent>in response to
http://postgis.refractions.net/pipermail/postgis-users/2011-May/029566.html.<BR>After
creating some indexes and rewriting geocode_address. I was
able to get geocode to run in 483-523 ms for "5775 Perimeter
Dr Dublin, Ohio". This used to take 1700-2000 ms for me. I'm
removing the main inner
qui<BR></TD></TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></DIV></BLOCKQUOTE></TD></TR></TBODY></TABLE></BODY></HTML>