From: Craig Ringer <craig@postnewspapers.com.au>
To: Gregory Youngblood <greg@tcscs.com>
Cc: david@lang.hm, Andrej Ricnik-Bay <andrej.groups@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: What is the best way to storage music files in Postgresql
Date: Wed, 19 Mar 2008 07:44:57 +0900
Message-ID: <47E045E9.8040809@postnewspapers.com.au> (raw)
In-Reply-To: <1205866336.483.5.camel@hammy>
References: <8fb205ea0803152311n2c950758g253f4cefd20cff7d@mail.gmail.com>
<47DCBD63.9050109@postnewspapers.com.au>
<4544e0330803171101g680ffa5bj8ac32908a9f3dfb5@mail.gmail.com>
<8fb205ea0803171139h63b55fdrf62776851583a74d@mail.gmail.com>
<4544e0330803172026h3eae59a1u8914bda1a5a95bb5@mail.gmail.com>
<b35603930803180213v6a3c2e64i8a65eca5472c0b49@mail.gmail.com>
<47DF9278.70605@postnewspapers.com.au>
<b35603930803181044y666f0e7r66b6d2606812a354@mail.gmail.com>
<alpine.DEB.1.00.0803181104010.21250@asgard.lang.hm>
<1205866336.483.5.camel@hammy>
Gregory Youngblood wrote:
> Also, a very informative read:
> http://research.google.com/archive/disk_failures.pdf
> In short, best thing to do is watch SMART and be prepared to try and
> swap a drive out before it fails completely. :)
>
I currently have four brand new 1TB disks (7200RPM SATA - they're for
our backup server). Two of them make horrible clicking noises - they're
rapidly parking and unparking or doing constant seeks. One of those two
also spins up very loudly, and on spin down rattles and buzzes.
Their internal SMART "health check" reports the problem two to be just
fine, and both pass a short SMART self test (smartctl -d ata -t short).
Both have absurdly huge seek_error_rate values, but the SMART thresholds
see nothing wrong with this.
The noisy spin down one is so defective that I can't even write data to
it successfully, and the other problem disk has regular I/O errors and
fails an extended SMART self test (the short test fails).
I see this sort of thing regularly. Vendors are obviously setting the
SMART health thresholds so that there's absolutely no risk of reporting
an issue with a working drive, and in the process making it basically
useless for detecting failing or faulty drives.
I rely on manual examination of the vendor attributes like the seek
error rate, ECC recovered sectors, offline uncorrectable sectors
(usually a REALLY bad sign if this grows), etc combined with regular
extended SMART tests (which do a surface scan). Just using SMART - say,
the basic health check - really isn't enough.
--
Craig Ringer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: craig@postnewspapers.com.au, greg@tcscs.com, andrej.groups@gmail.com
Subject: Re: What is the best way to storage music files in Postgresql
In-Reply-To: <47E045E9.8040809@postnewspapers.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox