Re: [PERFORM] Arguments Pro/Contra Software Raid - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: [PERFORM] Arguments Pro/Contra Software Raid
Date
Msg-id 5.2.1.1.1.20060514162127.027ea4f8@localhost
Whole thread Raw
In response to Re: [PERFORM] Arguments Pro/Contra Software Raid  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
At 11:53 AM 5/12/2006 -0400, Tom Lane wrote:

>Scott Ribe <scott_ribe@killerbytes.com> writes:
> >> My damn powerbook drive recently failed with very little warning
>
> > It seems to me that S.M.A.R.T. reporting is a crock of shit. I've had ATA
> > drives report everything OK while clearly in the final throes of death,
> just
> > minutes before total failure.
>
>FWIW, I replaced a powerbook's drive about two weeks ago myself, and its
>SMART reporting didn't show a darn thing wrong either.  Fortunately, the
>drive started acting noticeably weird (long pauses seemingly trying to
>recalibrate itself) while still working well enough that I was able to
>get everything copied off it.  I didn't wait for it to fail completely ;-)

Strange. With long pauses, usually you'd see stuff like "crc" errors in the
logs, and you'd get some info from the SMART monitoring stuff.

I guess a lot of it depends on the drive model and manufacturer.

SMART reporting is better than nothing, and it's actually not too bad. It's
just whether manufacturers implement it in useful ways or not.

I wouldn't trust the drive or manufacturer's judgement on when failure is
imminent - the drive usually gathers statistics etc and these are typically
readable with the SMART monitoring/reporting software, so you should check
those stats and decide for yourself when failure is imminent.

For example: I'd suggest regarding any non-cable related CRC errors, or
seek failures as "drive replacement time"- even if the drive or
Manufacturer thinks you need to have tons in a row for "failure imminent".

I recommend "blacklisting" drives which don't notice anything before it is
too late. e.g. even if it starts taking a long time to read a block, it
reports no differences in the SMART stats.

Link.



pgsql-general by date:

Previous
From: Markus Schiltknecht
Date:
Subject: Re: rules: evaluate inputs in advance
Next
From: Tino Wildenhain
Date:
Subject: Re: Mac Problem with Tunneling...