[postgis-users] Geocoding very slow (minutes)

Paragon Corporation lr at pcorp.us
Mon Jun 22 08:21:08 PDT 2015


Did you run 

 

Vacuum analyze verbose 

 

 

I loaded texas data and forgot to run vacuum analyze verbose after load.  It took 2 minutes, and after about 50 ms.

 

Thanks,

Regina

 

From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Wayne Seguin
Sent: Sunday, June 21, 2015 8:33 AM
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;

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/20150622/c0ea6be3/attachment.html>


More information about the postgis-users mailing list