Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 916F763621B for ; Wed, 1 Apr 2009 13:55:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 66403-02-7 for ; Wed, 1 Apr 2009 13:55:14 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f167.google.com (mail-ew0-f167.google.com [209.85.219.167]) by mail.postgresql.org (Postfix) with ESMTP id 6622663565F for ; Wed, 1 Apr 2009 13:55:02 -0300 (ADT) Received: by ewy11 with SMTP id 11so197424ewy.19 for ; Wed, 01 Apr 2009 09:55:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=xUy8xv54ptcEKb8yD6w9KNEDbwPBS5iEnvvZAtY/miA=; b=Rzrvkfq2umcG7kgWPs0b2MrfUSx72Y6ScMGW8DU/r6vVdBCc2A9R2dAEYqoozPTPYc dYMbWjFCuk8Yti/41F4Iz2Vd2Y4gGyGy9rnGB8LjwbRpnyjkXirOBaMgHnDs8YDuORv7 F8YsREV8O7Ecr35LtTl2NVO7tghSJTJW/Jp34= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=LQQhpp2/0+TgIlbz/OB6Wn4UdVrwjUk8EoJci7MLB1REp0AxQxEDNEmDKkY5zrqPBl qmqYl0UrRT95Z1f4yWIf6CKAI0Rao13/jIY4jrkFMx6fVp5ubJiotiJ7dqNc+qn/9SF1 537y2/v+80qg0AlmBuRKPaJ+39c0hlKiyM4o0= MIME-Version: 1.0 Received: by 10.210.139.15 with SMTP id m15mr6109090ebd.32.1238604898434; Wed, 01 Apr 2009 09:54:58 -0700 (PDT) In-Reply-To: <49D39AFA.8000700@ummon.com> References: <49D31E85.8050405@paradise.net.nz> <49D37CAA.6080100@ummon.com> <49D3932D.3080808@ummon.com> <49D39AFA.8000700@ummon.com> Date: Wed, 1 Apr 2009 10:54:58 -0600 Message-ID: Subject: Re: Raid 10 chunksize From: Scott Marlowe To: Stef Telford Cc: Greg Smith , Mark Kirkwood , Scott Carey , "pgsql-performance@postgresql.org" Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL=0.003 X-Spam-Level: X-Archive-Number: 200904/15 X-Sequence-Number: 33382 On Wed, Apr 1, 2009 at 10:48 AM, Stef Telford wrote: > Scott Marlowe wrote: >> On Wed, Apr 1, 2009 at 10:15 AM, Stef Telford wrote: >> >>> =A0 =A0 I do agree that the benefit is probably from write-caching, but= I >>> think that this is a 'win' as long as you have a UPS or BBU adaptor, >>> and really, in a prod environment, not having a UPS is .. well. Crazy ? >>> >> >> You do know that UPSes can fail, right? =A0En masse sometimes even. >> > Hello Scott, > =A0 =A0Well, the only time the UPS has failed in my memory, was during th= e > great Eastern Seaboard power outage of 2003. Lots of fond memories > running around Toronto with a gas can looking for oil for generator > power. This said though, anything could happen, the co-lo could be taken > out by a meteor and then sync on or off makes no difference. Meteor strike is far less likely than a power surge taking out a UPS. I saw a whole data center go black when a power conditioner blew out, taking out the other three power conditioners, both industrial UPSes and the switch for the diesel generator. And I have friends who have seen the same type of thing before as well. The data is the most expensive part of any server.