pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Gregory Youngblood <greg@tcscs.com>
To: david@lang.hm
Cc: Andrej Ricnik-Bay <andrej.groups@gmail.com>
Cc: Craig Ringer <craig@postnewspapers.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: What is the best way to storage music files in Postgresql
Date: Tue, 18 Mar 2008 11:52:16 -0700
Message-ID: <1205866336.483.5.camel@hammy> (raw)
In-Reply-To: <alpine.DEB.1.00.0803181104010.21250@asgard.lang.hm>
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>

On Tue, 2008-03-18 at 11:04 -0700, david@lang.hm wrote:

> On Wed, 19 Mar 2008, Andrej Ricnik-Bay wrote:
> 
> > 
> > On 18/03/2008, Craig Ringer <craig@postnewspapers.com.au> wrote:
> >> Isn't a 10 or 24 spindle RAID 5 array awfully likely to encounter a
> >>  double disk failure (such as during the load imposed by rebuild onto a
> >>  spare) ?
> 
> that's why you should use raid6 (allowing for dual failures)


And, if possible, try to use drives from a couple of different batches.
I wouldn't go crazy trying to do this, but sometimes a combination of
drives from two or three batches can make a difference (though not
always).

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. :)

view thread (21+ messages)  latest in thread

Message-ID: <1205866336.483.5.camel@hammy>
Permalink:  ../1205866336.483.5.camel@hammy/
Also on:    postgresql.org/message-id/1205866336.483.5.camel@hammy

 · 

reply
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: greg@tcscs.com, david@lang.hm, andrej.groups@gmail.com, craig@postnewspapers.com.au
  Subject: Re: What is the best way to storage music files in Postgresql
  In-Reply-To: <1205866336.483.5.camel@hammy>

* 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