[OSM-dev] osm2pgsql slim mode, postgis, and hard disk spindles
osm at stephans-server.de
Tue Sep 8 21:42:51 BST 2009
Richard Weait wrote:
> Jaunty, osm2pgsql from svn,
> p4, 3.4GHz
> single 150GB hard drive
> 50 hours.
Wow, 50 hours to apply the changes from a day.
I would be interested in having a wiki page to compare the typical
runtime. It would help a lot to determine what performance to expect
from a machine and to compare the own setup, so discover
In case we could get some comparable results I would set up a wiki page.
Here my measurements again. I did run an incremental update:
*** Old mapnik db timestamp
*** Start update
INFO: Osmosis Version 0.31.2
osm2pgsql SVN version 0.66-16423M
Mid: pgsql, scale=100, cache=3800MB, maxblocks=486401*8192
Node stats: total(3264066), max(489240074)
Way stats: total(106990), max(40421741)
Relation stats: total(2780), max(233957)
*** End update
*** New mapnik db timestamp
So that are 435 minutes. i7 920, 12GB, HW-Raid with high sequential speed
I tried to tune the DB with these settings (others are default):
With databases that huge as ours I suspect the disk subsystem being the
limiting factor. What would be a typical workload so to set up an
iometer (www.iometer.org) bench to compare the results?
More information about the dev