Fwd: Re: SSDD reliability - Mailing list pgsql-general

From David Boreham
Subject Fwd: Re: SSDD reliability
Date
Msg-id 4DC1A7E1.2040308@boreham.org
Whole thread Raw
Responses Re: Fwd: Re: SSDD reliability  (Greg Smith <greg@2ndQuadrant.com>)
List pgsql-general
>No problem with that, for a first step. ***BUT*** the failures in this article and
>many others I've read about are not in high-write db workloads, so they're not write wear,
>they're just crappy electronics failing.

As a (lapsed) electronics design engineer, I'm suspicious of the notion that
a subassembly consisting of solid state devices surface-mounted on FR4 substrate will fail
except in very rare (and of great interest to the manufacturer) circumstances.
And especially suspicious that one product category (SSD) happens to have a much
higher failure rate than all others.

Consider that an SSD is much simpler (just considering the electronics) than a traditional
disk drive, and subject to less vibration and heat.
Therefore one should see disk drives failing at the same (or higher rate).
Even if the owner is highly statically charged, you'd expect the to destroy all categories
of electronics at roughly the same rate (rather than just SSDs).

So if someone says that SSDs have "failed", I'll assume that they suffered from Flash cell
wear-out unless there is compelling proof to the contrary.





pgsql-general by date:

Previous
From: durumdara
Date:
Subject: ZEOS or PGDAC - How to lock a resource?
Next
From: "David Johnston"
Date:
Subject: GROUP BY Wildcard Syntax Thought