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 B7F2D9DC833 for ; Wed, 18 Jan 2006 14:09:57 -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 93755-08 for ; Wed, 18 Jan 2006 14:09:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from server10.araisoft.com (server10.araisoft.com [72.9.228.195]) by postgresql.org (Postfix) with ESMTP id B7BC89DC9FB for ; Wed, 18 Jan 2006 14:09:54 -0400 (AST) Received: from localhost (unknown [127.0.0.1]) by server10.araisoft.com (Postfix) with ESMTP id 38FDB3D6200E for ; Wed, 18 Jan 2006 10:09:51 -0800 (PST) Received: from server10.araisoft.com ([127.0.0.1]) by localhost (server10.araisoft.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11304-02 for ; Wed, 18 Jan 2006 10:09:46 -0800 (PST) Received: from uni (uni.cs.ucr.edu [138.23.204.215]) by server10.araisoft.com (Postfix) with ESMTP id 2DBE53D6200D for ; Wed, 18 Jan 2006 10:09:46 -0800 (PST) From: "Benjamin Arai" To: Subject: 3WARE Card performance boost? Date: Wed, 18 Jan 2006 10:09:46 -0800 Message-ID: <00ee01c61c5a$5db2c870$d7cc178a@uni> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00EF_01C61C17.4F8F8870" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 Thread-Index: AcYcWl0K9MCKAwJ5TNuMbMCEFq0pEQ== X-Virus-Scanned: by amavisd-new at araisoft.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.221 required=5 tests=[AWL=0.220, HTML_MESSAGE=0.001] X-Spam-Score: 0.221 X-Spam-Level: X-Archive-Number: 200601/302 X-Sequence-Number: 16780 This is a multi-part message in MIME format. ------=_NextPart_000_00EF_01C61C17.4F8F8870 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hi, I am currently doing large weekly updates with fsync=off. My updates involves SELECT, UPDATE, DELETE and etc. Setting fsync=off works for me since I take a complete backup before the weekly update and run a "sync" and "CHECKPOINT" after each weekly update has completed to ensure the data is all written to disk. 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? Benjamin Arai barai@cs.ucr.edu http://www.benjaminarai.com ------=_NextPart_000_00EF_01C61C17.4F8F8870 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Hi,

I am = currently doing=20 large weekly updates with fsync=3Doff. My updates involves SELECT, = UPDATE,=20 DELETE and etc. Setting fsync=3Doff works for me since I take a = complete=20 backup before the weekly update and run a "sync" and "CHECKPOINT" after = each=20 weekly update has completed to ensure the data is all written to = disk. =20

Obviously, I have=20 done this to improve write performance for the update each = week. My=20 question is if I install a 3ware or similar card to replace my = current=20 software RAID 1 configuration, am I going to see a very large = improvement? =20 If so, what would be a ball park figure?

Benjamin = Arai

barai@cs.ucr.edu

http://www.benjaminarai.com

------=_NextPart_000_00EF_01C61C17.4F8F8870--