Re: What is the best way to storage music files in Postgresql

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: What is the best way to storage music files in Postgresql
Дата
Msg-id 47E045E9.8040809@postnewspapers.com.au
обсуждение исходный текст
Ответ на What is the best way to storage music files in Postgresql  (Rich <rhdyes@gmail.com>)
Ответы Re: What is the best way to storage music files in Postgresql  (Gregory Youngblood <greg@tcscs.com>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Stephen Denne"
Дата:
Сообщение: Re: Planner mis-estimation using nested loops followup
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: What is the best way to storage music files in Postgresql