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 F228E9DCA0C for ; Wed, 18 Jan 2006 17:58:17 -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 84994-08 for ; Wed, 18 Jan 2006 17:58:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 0305E9DCA3D for ; Wed, 18 Jan 2006 17:58:13 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id DC6CF30F0A; Wed, 18 Jan 2006 22:58:15 +0100 (MET) From: William Yu X-Newsgroups: pgsql.performance Subject: Re: 3WARE Card performance boost? Date: Wed, 18 Jan 2006 13:58:09 -0800 Organization: Hub.Org Networking Services Lines: 15 Message-ID: References: <00ee01c61c5a$5db2c870$d7cc178a@uni> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.5 (Windows/20051201) In-Reply-To: <00ee01c61c5a$5db2c870$d7cc178a@uni> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.06 required=5 tests=[AWL=0.060] X-Spam-Score: 0.06 X-Spam-Level: X-Archive-Number: 200601/312 X-Sequence-Number: 16790 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=off. 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.