X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DD2489FB1A5; Thu, 11 May 2006 20:46:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 08785-01; Thu, 11 May 2006 20:45:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from candle.pha.pa.us (candle.pha.pa.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id 024859FB0D1; Thu, 11 May 2006 20:45:55 -0300 (ADT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id k4BNjsP16655; Thu, 11 May 2006 19:45:54 -0400 (EDT) From: Bruce Momjian Message-Id: <200605112345.k4BNjsP16655@candle.pha.pa.us> Subject: Re: [PERFORM] Arguments Pro/Contra Software Raid In-Reply-To: <20060511234124.GC4268@pervasive.com> To: "Jim C. Nasby" Date: Thu, 11 May 2006 19:45:54 -0400 (EDT) CC: "Joshua D. Drake" , Vivek Khera , "Pgsql-Performance ((E-mail))" , PostgreSQL General X-Mailer: ELM [version 2.4ME+ PL121 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/518 X-Sequence-Number: 95310 Jim C. Nasby wrote: > On Thu, May 11, 2006 at 07:20:27PM -0400, Bruce Momjian wrote: > > Joshua D. Drake wrote: > > > > > > >> You want an in-depth comparison of how a server disk drive is internally > > > >> better than a desktop drive: > > > >> > > > >> http://www.seagate.com/content/docs/pdf/whitepaper/D2c_More_than_Interface_ATA_vs_SCSI_042003.pdf > > > > > > > > BTW, someone (Western Digital?) is now offering SATA drives that carry > > > > the same MTBF/warranty/what-not as their SCSI drives. I can't remember > > > > if they actually claim that it's the same mechanisms just with a > > > > different controller on the drive... > > > > > > Well western digital and Seagate both carry 5 year warranties. Seagate I > > > believe does on almost all of there products. WD you have to pick the > > > right drive. > > > > That's nice, but it seems similar to my Toshiba laptop drive experience > > --- it breaks, we replace it. I would rather not have to replace it. :-) > > > > Let me mention the only drive that has ever failed without warning was a > > SCSI Deskstar (deathstar) drive, which was a hybrid because it was a > > SCSI drive, but made for consumer use. > > My damn powerbook drive recently failed with very little warning, other > than I did notice that disk activity seemed to be getting a bit slower. > IIRC it didn't log any errors or anything. Even if it did, if the OS was > catching them I'd hope it would pop up a warning or something. But from > what I've heard, some drives now-a-days will silently remap dead sectors > without telling the OS anything, which is great until you've used up all > of the spare sectors and there's nowhere to remap to. :( Yes, I think most IDE drives do silently remap, and most SCSI drives don't. Not sure how much _most_ is. I know my SCSI controller beeps at me when I try to access a bad block. Now, that gets my attention. -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +