| From: | Casey Allen Shobe <casey(at)shobe(dot)info> |
|---|---|
| To: | postgresql(dot)org(at)solomonson(dot)com |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Mixing an SSD and Spinning drive for best performance |
| Date: | 2013-01-14 17:38:03 |
| Message-ID: | CAFmVg3hcwsZwj8_jB2n3YSc9SfhBnuqXke2Dkn869uPbK8HKkA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, Jan 4, 2013 at 10:31 PM, <postgresql(dot)org(at)solomonson(dot)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(at)shobe(dot)info
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Casey Allen Shobe | 2013-01-14 17:43:11 | Re: How to implement the 'GRANT ALL ON DB1 TO 'USER'@'%' of MYSQL in PostgreSQL |
| Previous Message | Magnus Hagander | 2013-01-13 13:30:56 | Re: Postgres base Backup fails to recover all logs fails from archive |