I have installed Postgresql 9.3.5 and Postgis 2.1.2 on a 16Gb Ubuntu 14.04 system.
(1) If I load all the states TIGER data, using the scripts provided in Postgis, how big will the database be for the entire US? I have currently installed just the TIGER data for California (CA)?
(2) It takes about a minute to geocode an address. I have read the performance hints suggested here, How to improve poor performance times for PostGIS 2.1 Tiger Geocoder?, and have tried setting the shared memory buffer to a much larger value. I haven't been able to improve the query performance time. Do you have suggestions?
Thank you.
أكثر...
(1) If I load all the states TIGER data, using the scripts provided in Postgis, how big will the database be for the entire US? I have currently installed just the TIGER data for California (CA)?
(2) It takes about a minute to geocode an address. I have read the performance hints suggested here, How to improve poor performance times for PostGIS 2.1 Tiger Geocoder?, and have tried setting the shared memory buffer to a much larger value. I haven't been able to improve the query performance time. Do you have suggestions?
Thank you.
أكثر...