Re: [GENERAL] Recommendations for SSDs in production?

2011-11-25 Thread Yeb Havinga
On 2011-11-24 14:20, Yeb Havinga wrote: I really wonder at which point SSD life left will change to 99 on this drive.. Bingo! On the OCZ Vertex 2 PRO, SSD life left to 99 after just over 100PB written. 230 Life_Curve_Status 0x0013 100 100 000Pre-fail Always -

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-24 Thread Yeb Havinga
On 2011-11-04 16:24, David Boreham wrote: On 11/4/2011 8:26 AM, Yeb Havinga wrote: First, if your'e interested in doing a test like this yourself, I'm testing on ubuntu 11.10, but even though this is a brand new distribution, the smart database was a few months old. 'update-smart-drivedb'

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-08 Thread Vick Khera
On Wed, Nov 2, 2011 at 1:01 PM, Benjamin Smith li...@benjamindsmith.com wrote: I don't mind spending some money. Can anybody comment on a recommended drive in real world use? We have been using the RamSan-620 from Texas Memory Systems http://www.ramsan.com/ for over a year now on a heavy write

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-04 Thread Thomas Mieslinger
Am 03.11.2011 18:59, schrieb Robert Treat: On Wed, Nov 2, 2011 at 11:02 PM, Benjamin Smith li...@benjamindsmith.com wrote: On Wednesday, November 02, 2011 11:39:25 AM Thomas Strunz wrote: I guess go Intel route or some other crazy expensive enterprise stuff. It's advice about some of the

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-04 Thread Yeb Havinga
On 2011-11-04 04:21, Kurt Buff wrote: Oddly enough, Tom's Hardware has a review of the Intel offering today - might be worth your while to take a look at it. Kurt Thanks for that link! Seeing media wearout comparisons between 'consumer grade' and 'enterprise' disks was enough for me to stop

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-04 Thread David Boreham
On 11/4/2011 8:26 AM, Yeb Havinga wrote: First, if your'e interested in doing a test like this yourself, I'm testing on ubuntu 11.10, but even though this is a brand new distribution, the smart database was a few months old. 'update-smart-drivedb' had as effect that the names of the values

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-03 Thread Benjamin Smith
On Wednesday, November 02, 2011 11:39:25 AM Thomas Strunz wrote: I have no idea what you do but just the fact that you bought ssds to improve performance means it's rather high load and hence important. Important enough that we back everything up hourly. Because of this, we decided to give

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-03 Thread Benjamin Smith
On Wednesday, November 02, 2011 01:01:47 PM Yeb Havinga wrote: Could you tell a bit more about the sudden death? Does the drive still respond to queries for smart attributes? Just that. It's almost like somebody physically yanked them out of the machine, after months of 24x7 perfect

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-03 Thread Yeb Havinga
On 2011-11-03 04:02, Benjamin Smith wrote: Which is what we're trying next, X25E. 710's apparently have 1/5th the rated write endurance, without much speed increase, so don't seem like such an exciting product. I've tested the 710 with diskchecker.pl and it doesn't lie about it's cache

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-03 Thread Allan Kamau
On Thu, Nov 3, 2011 at 6:02 AM, Benjamin Smith li...@benjamindsmith.com wrote: On Wednesday, November 02, 2011 11:39:25 AM Thomas Strunz wrote: I have no idea what you do but just the fact that you bought ssds to improve performance means it's rather high load and hence important. Important

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-03 Thread Robert Treat
On Wed, Nov 2, 2011 at 11:02 PM, Benjamin Smith li...@benjamindsmith.com wrote: On Wednesday, November 02, 2011 11:39:25 AM Thomas Strunz wrote: I guess go Intel route or some other crazy expensive enterprise stuff. It's advice about some of the crazy expensive enterprise stuff that I'm

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-03 Thread Michael Nolan
On Thu, Nov 3, 2011 at 4:15 AM, Allan Kamau kamaual...@gmail.com wrote: How about SSDs on Raid 1+0 (I have no experience on SSD and RAID though) and have replication to another server having the same setup and still do frequent backups. The Crucial m4 SSDs seem to be reasonably priced and

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-03 Thread Benjamin Smith
On Thursday, November 03, 2011 10:59:37 AM you wrote: There's a pretty varied mix of speed, durability, and price with any SSD based architecture, but the two that have proven best in our testing and production use (for ourselves and our clients) seem to be Intel (mostly 320 series iirc), and

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-03 Thread Kurt Buff
On Thu, Nov 3, 2011 at 16:15, Benjamin Smith li...@benjamindsmith.com wrote: On Thursday, November 03, 2011 10:59:37 AM you wrote: There's a pretty varied mix of speed, durability, and price with any SSD based architecture, but the two that have proven best in our testing and production use

[GENERAL] Recommendations for SSDs in production?

2011-11-02 Thread Benjamin Smith
Well, After reading several glowing reviews of the new OCZ Vertex3 SSD last spring, we did some performance testing in dev on RHEL6. (CentOS) The results were nothing short of staggering. Complex query results returned in 1/10th the time as a pessimistic measurement. System loads dropped

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-02 Thread Merlin Moncure
On Wed, Nov 2, 2011 at 12:01 PM, Benjamin Smith li...@benjamindsmith.com wrote: Well, After reading several glowing reviews of the new OCZ Vertex3 SSD last spring, we did some performance testing in dev on RHEL6. (CentOS) The results were nothing short of staggering. Complex query results

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-02 Thread David Boreham
On 11/2/2011 11:01 AM, Benjamin Smith wrote: 2) Intel X25E - good reputation, significantly slower than the Vertex3. We're buying some to reduce downtime. If you don't mind spending money, look at the new 710 Series from Intel. Not SLC like the X25E, but still specified with a very high

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-02 Thread John R Pierce
you really need to watch out for excess write caching on SSDs. only a few are safe against power failures while under heavy database write activity. -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-02 Thread Thomas Strunz
recent ssd is orders of magnitude faster in that are compared to HDD even the slow Intel drives. Regards, Thomas Date: Wed, 2 Nov 2011 12:18:10 -0500 Subject: Re: [GENERAL] Recommendations for SSDs in production? From: mmonc...@gmail.com To: li...@benjamindsmith.com CC: pgsql-general

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-02 Thread John R Pierce
On 11/02/11 11:39 AM, Thomas Strunz wrote: For database I assume random read and writes are by way the most important thing and any recent ssd is orders of magnitude faster in that are compared to HDD even the slow Intel drives. actually, SSD's have issues with committed small block (8K)

Re: [GENERAL] Recommendations for SSDs in production?

2011-11-02 Thread Yeb Havinga
On 2011-11-02 18:01, Benjamin Smith wrote: So after months of using this SSD without any issues at all, we tentatively rolled this out to production, and had blissful, sweet beauty until about 2 weeks ago, now we are running into sudden death scenarios. Could you tell a bit more about the