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

Filed under:
|
|
|
|

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

Related posts about macosx

Related posts about database