database on SSD: data only or the DBM program too?
Posted
by
simone
on Server Fault
See other posts from Server Fault
or by simone
Published on 2012-09-24T14:34:41Z
Indexed on
2012/09/24
15:39 UTC
Read the original article
Hit count: 350
I plan on moving the data I use for statistical analysis (100-ish Gb) onto an SSD. The data is either sqlite single-file db's, or postgresql-managed data. The SSD is 240 Gb, 550 MB/s read and 520 MB/s write.
Should I reserve that space for the data only, or would it be a good idea to install the operating system (Mac OS X) and the application directory (Adobe Suite, Microsoft Office and the like) on the SSD too?
And would it make a substantial speed difference whether I also install the postgresql binaries on the SSD?
I have plenty of other space (another 300Gb hard-drive, and a 1Tb one). Don't know the features of the non-SSD drives, though they're our standard equipment on all Macs, and they're definitely OK.
Thanks.
© Server Fault or respective owner