Postgres Pro
Downloads
Home   >   mailing lists

Mixing an SSD and Spinning drive for best performance - Mailing list pgsql-admin

From postgresql.org@solomonson.com
Subject Mixing an SSD and Spinning drive for best performance
Date
Msg-id CAKvtvXpBN+Oz-STNVv75H1EiGqiyGgP3Gb0snn_Q-c79wA3xAA@mail.gmail.com
Whole thread Raw
Responses Re: Mixing an SSD and Spinning drive for best performance  (Casey Allen Shobe <casey@shobe.info>)
List pgsql-admin
Tree view
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:
  1. SSD for data and OS. Spinning for temp space.
  2. SSD for data. Spinning for OS and temp space.
  3. 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?

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Phantom half-install: How can I remove it completely?
Next
From: CS DBA
Date:
Subject: 9.2.2 build error