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
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
