Mixing an SSD and Spinning drive for best performance
Mixing an SSD and Spinning drive for best performance
От:
postgresql.org@solomonson.com
Дата:
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?
Re: Mixing an SSD and Spinning drive for best performance
От:
Casey Allen Shobe <casey@shobe.info>
Дата:
On Fri, Jan 4, 2013 at 10:31 PM, <postgresql.org@solomonson.com> wrote:
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.
I agree, though you probably want to consider setting up multiple tablespaces, so that you can move data between disk subsystems via alter.
Cheers,
--
Casey Allen Shobe
casey@shobe.info