OSM database on SSD

I'm experimenting with importing the OSM database to a solid state disk. I hear they can be pretty fast. I expect it will take time to get the configuration right.

Default settings, mounted with noatime

First try it with all settings as default as possible. Mount the ssd with noatime to reduce writes to the ssd.

fdisk whole disk as one partition
mke2fs -t ext3 /dev/sdd1
# /etc/fstab
/dev/sdd1  /ssd  ext3   noatime  0 0 
# create tablespace on ssd
# create db on tablespace
# time ./osm2pgsql -S default.style --slim -d green -C 2048 /home/nerd/planet/planet-100421.osm.bz2

It is running now, so let's see...

Results: tbd

Any updates on this? How

Any updates on this? How fast does it get? How many writes hit the SSD? Will a consumer grade SSD survive it for a longer time applying minutely updates?

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <q> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <h1> <h2> <h3> <h4> <pre> <sup> <sub> <blockquote>
  • Lines and paragraphs break automatically.

More information about formatting options