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 79AE69DC9E1 for ; Wed, 18 Jan 2006 15:12:48 -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 07911-04 for ; Wed, 18 Jan 2006 15:12:45 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.194]) by postgresql.org (Postfix) with ESMTP id 973CC9DCA03 for ; Wed, 18 Jan 2006 15:12:43 -0400 (AST) Received: by uproxy.gmail.com with SMTP id s2so4161uge for ; Wed, 18 Jan 2006 11:12:43 -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=Jd5qg+cDMnQlLqIEs4oO0yVwjwhgEe6yPiDNWEbUiBXPIQABsgRqWzHcGiWG9fhqOB57eLSpt5WyB6uMWRWENKSjqbqJ1nomfixDOg02AUDyJiTEeN5hIEOwrI2tQ7/rhyzNLCHPLLClTWxpesqQBZdOB+XpUBPLCpJW6QhHXgo= Received: by 10.66.254.16 with SMTP id b16mr2684036ugi; Wed, 18 Jan 2006 11:12:43 -0800 (PST) Received: by 10.67.22.1 with HTTP; Wed, 18 Jan 2006 11:12:43 -0800 (PST) Message-ID: <33c6269f0601181112t4ab4c2b0wd48a4e47ab5e71ec@mail.gmail.com> Date: Wed, 18 Jan 2006 14:12:43 -0500 From: Alex Turner To: "Joshua D. Drake" Subject: Re: 3WARE Card performance boost? Cc: Benjamin Arai , pgsql-performance@postgresql.org In-Reply-To: <43CE87D1.6010904@commandprompt.com> 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> <43CE87D1.6010904@commandprompt.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/306 X-Sequence-Number: 16784 http://www.3ware.com/products/serial_ata2-9000.asp Check their data sheet - the cards are BBU ready - all you have to do is order a BBU which you can from here: http://www.newegg.com/Product/Product.asp?Item=3DN82E16815999601 Alex. On 1/18/06, Joshua D. Drake 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? > > Well that entirely depends on what level... > > 1. I would suggest LSI 150-6 not 3ware > > Why? > > Because 3ware does not make a midrange card that has a battery backed > cache :). That is the only reason. 3ware makes good stuff. > > So anyway... LSI150-6 with Battery Backed cache option. Put 6 drives > on it with a RAID 10 array, turn on write cache and you should have > a hauling drive. > > Joshua D. Drake > > > > > > > *Benjamin Arai* > > barai@cs.ucr.edu > > http://www.benjaminarai.com > > > > > -- > The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > Managed Services, Shared and Dedicated Hosting > Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >