Hello-
I have a large Postgres database on Ubuntu 12 (+100GB). I
have an old, SATA-based, spinning drive and a new SSD drive. I mainly
do data analysis on Postgres (big, ugly select statements). I see a few
options:- SSD for data and OS. Spinning for temp space.
- SSD for data. Spinning for OS and temp space.
- SSD for OS. Spinning for data and temp space.
I'm thinking that option #2 is the best. But, I wonder if moving the
OS on the SSD will give me a boost. I'm not too concerned about boot
up time or OS responsiveness as much as getting more speed out of my DB
queries. I have plenty of space on both drives for the data and OS with room to spare.
Which configuration would you recommend? Any other suggestions to get more performance?
