<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" data-hsystem="true"></head>
<body><style>p{margin: 0;padding: 0;}
</style>
<p><br>Hi Wayne -</p>
<p> </p>
<p> yes, there is no way it should be minutes.. two things:</p>
<p>one is .. you wont want to hear this, but, setting up a single *small* state
instead of "everything" helps to refine your process</p>
<p>two, you can prepend EXPLAIN ANALYZE to your query... and use the fine web
service http://explain.depesz.com/</p>
<blockquote style="border-left: 2px solid #000000; padding-right: 0px;
padding-left: 5px; margin-left: 5px; margin-right: 0px;">Date: Sun, 21 Jun 2015
08:32:41 -0400<br> From: Wayne Seguin <wseguin@gmail.com><br> To:
"postgis-users@lists.osgeo.org" <postgis-users@lists.osgeo.org><br>
Subject: [postgis-users] Geocoding very slow (minutes)<br><br> Brand new
installation of PostgreSQL 9.4.4 with latest PostGIS as an Extension and 2014
tiger data. 100% loaded and indexed.<br><br> Geocoding any address is taking 1-2
minutes per. Something is wrong, but no way to tell what. Checked and all data
and indexes are present. System is a 4-core 16Gb ram, SSD-based machine.<br><br>
SELECT * FROM geocode(normalize_address('4150 International Plaza Fort Worth TX
76109')) As g;<br><br>
</blockquote>
</body>
</html>