[Geocoding] size of placex

[Brian DeRocher]

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