From: | Scott Carey <scott(at)richrelevance(dot)com> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | Yeb Havinga <yebhavinga(at)gmail(dot)com>, Hannu Krosing <hannu(at)2ndquadrant(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Greg Smith <greg(at)2ndquadrant(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Testing Sandforce SSD |
Date: | 2010-08-04 19:58:39 |
Message-ID: | 3B33CDA4-1CAD-4265-8FB3-6E43674FCA77@richrelevance.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Aug 3, 2010, at 9:27 AM, Merlin Moncure wrote:
>
> 2) I've heard that some SSD have utilities that you can use to query
> the write cycles in order to estimate lifespan. Does this one, and is
> it possible to publish the output (an approximation of the amount of
> work along with this would be wonderful)?
>
On the intel drives, its available via SMART. Plenty of hits on how to read the data from google. Sandforce drives probably have it exposed via SMART as well.
I have had over 50 X25-M's (80GB G1's) in production for 22 months that write ~100GB a day and SMART reports they have 78% of their write cycles left. Plus, when it dies from usage it supposedly enters a read-only state. (these only have recoverable data so data loss on power failure is not a concern for me).
So if Sandforce has low write amplification like Intel (they claim to be better) longevity should be fine.
> merlin
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2010-08-04 20:24:40 | Re: Questions on query planner, join types, and work_mem |
Previous Message | Kevin Grittner | 2010-08-04 19:58:08 | Re: Questions on query planner, join types, and work_mem |