Re: Recommendations for SSDs in production?

On Thu, Nov 3, 2011 at 6:02 AM, Benjamin Smith <lists(at)benjamindsmith(dot)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 enough that we back everything up hourly. Because of this, we
> decided to give the SSDs a try.
>
>> Using a consumer drive for that IMHO is not the best idea. I know a lot
>> about ssds but just in consumer space. Intel has a good reputation in
>> terms of reliability but they are not the fastest.
>
> 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 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
> seeking...? I don't mind spending some money if I get to keep up this level of
> performance, but also am not looking to make somebody's private plane payment,
> either.
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

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 perform well.
The savings on power and cooling may be used in offsetting some of
cost of the warm standby server.

Allan.