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

From: David Boreham <david_list(at)boreham(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
Date: 2011-10-24 23:18:18
Message-ID: 4EA5F23A.4040900@boreham.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 10/24/2011 3:31 PM, Merlin Moncure wrote:
>> 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).

I disagree with this (that it is the only reason to select 710 series).
The write endurance (specified at least) is orders of magnitude higher.
Doing 100's of TPS constantly it is possible to burn through the 320's
endurance
lifetime in a year or two.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2011-10-25 02:17:39 Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
Previous Message Claudio Freire 2011-10-24 22:47:01 Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server