postgres

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.  read more »

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