Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Oct 24, 2011 at 11:53 AM, David Boreham <david_list@xxxxxxxxxxx> wrote:
>
> A few quick thoughts:
>
> 1. 320 would be the only SSD I'd trust from your short-list. It's the only
> one with proper protection from unexpected power loss.

yeah.

> 2. Multiple RAID'ed SSDs sounds like (vast) overkill for your workload. A
> single SSD should be sufficient (will get you several thousand TPS on
> pgbench for your DB size).

Also, raid controllers interfere with TRIM.

> 3. Consider not using the magnetic disks at all (saves on space, power and
> the cost of the RAID controller for them).

Agree.  If one SSD did not deliver the tps, I'd consider buying more
and optimizing with jbod/tablespaces -- really doubt that's necessary
however. Maybe a single large slow magnetic disk is a good idea for
retaining backups though.

> 4. Consider using Intel 710 series rather than 320 (pay for them with the
> money saved from #3 above). Those devices have much, much higher specified
> endurance than the 320s and since your DB is quite small you only need to
> buy one of them.

710 is good idea if and only if you are worried about write durability
(in which case it's a great idea).

merlin

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux