Frederik,
On Wednesday 17 August 2011 17:25:16 you wrote:
> From the
> non-answers here on geocoding I also get the impression that practially
> nobody except MapQuest are running a world-wide Nominatim so if you
> are, I am more than interested in the sizes and performance info of
> your system.
Well i intend to run a world-wide Nominatim. I'm still running the
import/index.
My system now has
2 old dual core Opterons
16 GB ram
Areca 1130 RAID5 2TB w/BBU /data
250GB /data-wal
Debian 6
PG 8.4
work_mem = 256MB
maintenance_work_mem = 256MB
checkpoint_segments = 20
fsync = off
shared_buffers = 4GB
I'm currently running the gazetteer-loaddata.sql script. Ways are taking a
long time. I'm thinking i should stop here, move this database to a non-RAID
disk, finish loaddata.sql, and move it back later.
osm_id % 100 = 31 just finished. It took 11.2 hours. Each osm_id (mod 100)
takes longer than the previous. This increase appears to be linear. I
estimate the rest will take 55 days.
At 31% done:
place is 35GB
placex is 18GB
planet_osm_nodes 63GB
planet_osm_ways is 55GB
The other tables you mentioned, like place_addressline, search_name_*,
location_road_2 are much smaller, all less that 1MB.
Brian
--
Brian DeRocher
http://brian.derocher.org
_______________________________________________
Geocoding mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/geocoding
