Re: [pgsql-performance] Daily digest v1.3606 (10 messages) - Mailing list pgsql-performance

From John Lister
Subject Re: [pgsql-performance] Daily digest v1.3606 (10 messages)
Date
Msg-id 4FB2C61C.40906@kickstone.com
Whole thread Raw
Responses Re: [pgsql-performance] Daily digest v1.3606 (10 messages)
List pgsql-performance
>We've reached to the point when we would like to try SSDs. We've got a
>central DB currently 414 GB in size and increasing. Working set does not
>fit into our 96GB RAM server anymore.
>So, the main question is what to take. Here what we've got:
>1) Intel 320. Good, but slower then current generation sandforce drives
>2) Intel 330. Looks like cheap 520 without capacitor
>3) Intel 520. faster then 320 No capacitor.
>4) OCZ Vertex 3 Pro - No available. Even on OCZ site
>5) OCZ Deneva - can't find in my country :)
>We are using Areca controller with BBU. So as for me, question is: Can 520
>series be set up to handle fsyncs correctly? We've got the Areca to handle
>buffering.

I was thinking the same thing, setting up a new server with ssds instead of hdds as I currently have
and was wondering what the thoughts are in regards to using raid (it would probably be a dell R710 card -
any comments on these as they are new). I was planning on using intel 320s as the 710s are a little too
pricey at the moment and we aren't massively heavy on the writes (but can revisit this in the next
6months/year if required). I was thinking raid 10 as I've done with the hdds, but not sure if this is the
best choice for ssds, given wear level and firmware is likely to be the same, I'd expect concurrent
failure on a stipe. Therefore I'd imagine using an alternate mfr/drive for the mirrors is a better bet?

What are peoples thoughts on using a non enterprise drive for this - the choice of enterprise drives is limited :(

I was thinking if we have sudden power failure then mark the consumer drive as bad and rebuild it from the other one,
or is this highly risky?

Does any one do anything different?

Thanks

John


pgsql-performance by date:

Previous
From: David Boreham
Date:
Subject: Re: SSD selection
Next
From: Merlin Moncure
Date:
Subject: Re: [pgsql-performance] Daily digest v1.3606 (10 messages)