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

From Casey Allen Shobe
Subject Re: Mixing an SSD and Spinning drive for best performance
Date
Msg-id CAFmVg3hcwsZwj8_jB2n3YSc9SfhBnuqXke2Dkn869uPbK8HKkA@mail.gmail.com
Whole thread Raw
In response to Mixing an SSD and Spinning drive for best performance  (postgresql.org@solomonson.com)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Postgres base Backup fails to recover all logs fails from archive
Next
From: Casey Allen Shobe
Date:
Subject: Re: How to implement the 'GRANT ALL ON DB1 TO 'USER'@'%' of MYSQL in PostgreSQL