[postgis-users] Geocoding very slow (minutes)
Wayne Seguin
wseguin at gmail.com
Sun Jun 21 05:32:41 PDT 2015
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;
Might have narrowed it down to the big select at the end of the geocode() function, but since I do have all indexes, I'm at a loss to figure out what's wrong.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150621/4ce7495d/attachment.html>
More information about the postgis-users
mailing list