Mixing an SSD and Spinning drive for best performance

From: postgresql(dot)org(at)solomonson(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: Mixing an SSD and Spinning drive for best performance
Date: 2013-01-05 03:31:28
Message-ID: CAKvtvXpBN+Oz-STNVv75H1EiGqiyGgP3Gb0snn_Q-c79wA3xAA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message CS DBA 2013-01-05 17:58:03 9.2.2 build error
Previous Message Tom Lane 2013-01-04 19:54:30 Re: Phantom half-install: How can I remove it completely?