Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id EC36F63307D for ; Wed, 1 Apr 2009 14:17:33 -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 72437-02 for ; Wed, 1 Apr 2009 14:17:30 -0300 (ADT) X-Greylist: delayed 00:06:41.30852 by SQLgrey-1.7.6 Received: from p3plsmtpa01-01.prod.phx3.secureserver.net (p3plsmtpa01-01.prod.phx3.secureserver.net [72.167.82.81]) by mail.postgresql.org (Postfix) with SMTP id BFCA1632D93 for ; Wed, 1 Apr 2009 14:17:31 -0300 (ADT) Received: (qmail 18109 invoked from network); 1 Apr 2009 17:10:49 -0000 Received: from unknown (72.136.44.124) by p3plsmtpa01-01.prod.phx3.secureserver.net (72.167.82.81) with ESMTP; 01 Apr 2009 17:10:49 -0000 Message-ID: <49D3A018.7090700@ummon.com> Date: Wed, 01 Apr 2009 13:10:48 -0400 From: Stef Telford User-Agent: Thunderbird 2.0.0.21 (X11/20090319) MIME-Version: 1.0 To: Matthew Wakeling CC: "pgsql-performance@postgresql.org" Subject: Re: Raid 10 chunksize References: <49D31E85.8050405@paradise.net.nz> <49D37CAA.6080100@ummon.com> <49D3932D.3080808@ummon.com> <49D39AFA.8000700@ummon.com> In-Reply-To: X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200904/19 X-Sequence-Number: 33386 Matthew Wakeling wrote: > On Wed, 1 Apr 2009, Stef Telford wrote: >> Good UPS, a warm PITR standby, offsite backups and regular checks is >> "good enough" for me, and really, that's what it all comes down to. >> Mitigating risk and factors into an 'acceptable' amount for each person. >> However, if you see over a 2x improvement from turning write-cache 'on' >> and have everything else in place, well, that seems like a 'no-brainer' >> to me, at least ;) > > In that case, buying a battery-backed-up cache in the RAID controller > would be even more of a no-brainer. > > Matthew > Hey Matthew, See about 3 messages ago.. We already have them (I did say UPS or BBU, it should have been a logical 'and' instead of logical 'or' .. my bad ;). Your right though, that was a no-brainer as well. I am wondering how the card (3ware 9550sx) will work with SSD's, md or lvm, blocksize, ext3 or ext4 .. but.. this is the point of benchmarking ;) Regards Stef