[postgis-users] Geocoding very slow (minutes)

[Brian M Hamlin]

Hi Wayne -
 
  yes, there is no way it should be minutes.. two things:
one is .. you wont want to hear this, but, setting up a single *small* 
state instead of "everything" helps to refine your process
two, you can prepend EXPLAIN ANALYZE to your query... and use the fine 
web service http://explain.depesz.com/

       Date: Sun, 21 Jun 2015 08:32:41 -0400
From: Wayne Seguin
To: "postgis-users at lists.osgeo.org"

Subject: [postgis-users] Geocoding very slow (minutes)

Brand new installation of PostgreSQL 9.4.4 with latest PostGIS as an 
Extension and 2014 tiger data. 100% loaded and indexed. 

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. 

SELECT * FROM geocode(normalize_address('4150 International Plaza Fort 
Worth TX 76109')) As g;


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150621/c358b577/attachment.html>