Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server - Mailing list pgsql-performance

From David Boreham
Subject Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
Date
Msg-id 4EA5F23A.4040900@boreham.org
Whole thread Raw
In response to Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server  (Merlin Moncure <mmoncure@gmail.com>)
List 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.



pgsql-performance by date:

Previous
From: Claudio Freire
Date:
Subject: Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
Next
From: Robert Haas
Date:
Subject: Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter