X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8328C9DCB53 for ; Thu, 19 Jan 2006 18:54:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28793-07 for ; Thu, 19 Jan 2006 18:54:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.202]) by postgresql.org (Postfix) with ESMTP id AF4ED9DCB4F for ; Thu, 19 Jan 2006 18:54:30 -0400 (AST) Received: by uproxy.gmail.com with SMTP id s2so104484uge for ; Thu, 19 Jan 2006 14:54:32 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=RGqtYpNhmSlDgi+EEcwOrBUDnp9WsjYl/xHSzWjCiSFGrELokiDcVTDIUUTs8HCrTGiI8dAwtOoO5+JUsaDtM9l5pAVptk9aH8U5jiNwIZdpNo3prtumFK58KX1MFKjgmHU5EM1bFpyKKpUdQwYbdLIZdC2hajGQ9MxqrBAy4vw= Received: by 10.66.241.1 with SMTP id o1mr485432ugh; Thu, 19 Jan 2006 14:54:32 -0800 (PST) Received: by 10.67.22.1 with HTTP; Thu, 19 Jan 2006 14:54:32 -0800 (PST) Message-ID: <33c6269f0601191454u65191b61vcd105256db94a78d@mail.gmail.com> Date: Thu, 19 Jan 2006 17:54:32 -0500 From: Alex Turner To: William Yu Subject: Re: 3WARE Card performance boost? Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <00ee01c61c5a$5db2c870$d7cc178a@uni> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.209 required=5 tests=[AWL=0.209] X-Spam-Score: 0.209 X-Spam-Level: X-Archive-Number: 200601/333 X-Sequence-Number: 16811 He's talking about RAID 1 here, not a gargantuan RAID 6. Onboard RAM on the controller card is going to make very little difference. All it will do is allow the card to re-order writes to a point (not all cards even do this). Alex. On 1/18/06, William Yu wrote: > Benjamin Arai wrote: > > Obviously, I have done this to improve write performance for the update > > each week. My question is if I install a 3ware or similar card to > > replace my current software RAID 1 configuration, am I going to see a > > very large improvement? If so, what would be a ball park figure? > > The key is getting a card with the ability to upgrade the onboard ram. > > Our previous setup was a LSI MegaRAID 320-1 (128MB), 4xRAID10, > fsync=3Doff. Replaced it with a ARC-1170 (1GB) w/ 24x7200RPM SATA2 drives > (split into 3 8-drive RAID6 arrays) and performance for us is through > the ceiling. > > For OLTP type updates, we've gotten about +80% increase. For massive > 1-statement updates, performance increase is in the +triple digits. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >