[postgis-users] Geocoding on Windows very slow

[Jonathan Haglund]

The following query takes around 28 seconds to complete:

select g.rating, ST_X(geomout) as lon, ST_Y(geomout) as lat, (addy).*
from geocode( '601 15th Ave NW, Birmingham, Alabama, 35215', 1 ) as g

I did select install_missing_indexes(), tried vacuum analyze on the 
top-level tables, and thrown lots of resources and posgresql.  My system 
does not want for CPU or ram, the databases are on a raid 10.  I have 17 
states' data loaded, in case that matters.

When I loaded the tiger data I ran into a problem with the windows 
version of the scripts and had to alter the top-level tables before 
being able to do the states.  As a result tlid moved to the last 
position.  I made no other alterations.  I think this would affect index 
performance on mysql but I don't have experience with this in 
postgresql, so that's part of my question.

What might I look for next in troubleshooting?  Does 2.1 promise to fix 
all my woes as I have read in other performance questions?

My versions:

PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit 
POSTGIS="2.0.3 r11132" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March 
2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8" 
LIBJSON="UNKNOWN" RASTER