Re: New server setup

From: John Lister <john(dot)lister(at)kickstone(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: New server setup
Date: 2013-03-13 20:05:52
Message-ID: 5140DC20.60306@kickstone.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 13/03/2013 19:23, Steve Crawford wrote:
> On 03/13/2013 09:15 AM, John Lister wrote:
>> On 13/03/2013 15:50, Greg Jaskiewicz wrote:
>>> SSDs have much shorter life then spinning drives, so what do you do
>>> when one inevitably fails in your system ?
>> Define much shorter? I accept they have a limited no of writes, but
>> that depends on load. You can actively monitor the drives "health"
>> level...
>
> What concerns me more than wear is this:
>
> InfoWorld Article:
> http://www.infoworld.com/t/solid-state-drives/test-your-ssds-or-risk-massive-data-loss-researchers-warn-213715
>
When I read this they didn't name the drives that failed - or those that
passed. But I'm assuming the failed ones are standard consumer SSDS, but
2 good ones were either enterprise of had caps. The reason I say this,
is that yes SSD drives by the nature of their operation cache/store
information in ram while they write it to the flash and to handle the
mappings, etc of real to virtual sectors and if they loose power it is
this that is lost, causing at best corruption if not complete loss of
the drive. Enterprise drives (and some consumer, such as the 320s) have
either capacitors or battery backup to allows the drive to safely
shutdown. There have been various reports both on this list and
elsewhere showing that these drives successfully survive repeated power
failures.

A bigger concern is the state of the firmware in these drives which
until recently was more likely to trash your drive - fortunately things
seems to becoming more stable with age now.

John

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Boreham 2013-03-13 20:16:16 Re: New server setup
Previous Message CSS 2013-03-13 19:47:14 Re: New server setup