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 CD5CA9DC833 for ; Wed, 18 Jan 2006 14:26:44 -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 99365-01 for ; Wed, 18 Jan 2006 14:26:43 -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 328ED9DC9F2 for ; Wed, 18 Jan 2006 14:26:42 -0400 (AST) Received: from localhost (unknown [127.0.0.1]) by server10.araisoft.com (Postfix) with ESMTP id DA7A13D6200F for ; Wed, 18 Jan 2006 10:26:41 -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 02858-01 for ; Wed, 18 Jan 2006 10:26:37 -0800 (PST) Received: from uni (uni.cs.ucr.edu [138.23.204.215]) by server10.araisoft.com (Postfix) with ESMTP id C32C03D6200D for ; Wed, 18 Jan 2006 10:26:36 -0800 (PST) From: "Benjamin Arai" To: Subject: Re: 3WARE Card performance boost? Date: Wed, 18 Jan 2006 10:26:37 -0800 Message-ID: <011201c61c5c$b81cc520$d7cc178a@uni> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0113_01C61C19.A9F98520" X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <00ee01c61c5a$5db2c870$d7cc178a@uni> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 Thread-Index: AcYcWl0K9MCKAwJ5TNuMbMCEFq0pEQAAk7CA X-Virus-Scanned: by amavisd-new at araisoft.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.199 required=5 tests=[AWL=0.198, HTML_MESSAGE=0.001] X-Spam-Score: 0.199 X-Spam-Level: X-Archive-Number: 200601/304 X-Sequence-Number: 16782 This is a multi-part message in MIME format. ------=_NextPart_000_0113_01C61C19.A9F98520 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit My original plan was to buy a 3WARE card and put a 1GB of memory on it to improve writes but I am not sure if that is actually going to help the issue if fsync=off. Benjamin Arai barai@cs.ucr.edu http://www.benjaminarai.com _____ From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Benjamin Arai Sent: Wednesday, January 18, 2006 10:10 AM To: pgsql-performance@postgresql.org Subject: [PERFORM] 3WARE Card performance boost? 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_0113_01C61C19.A9F98520 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

My original plan was to buy a 3WARE card and = put a 1GB of=20 memory on it to improve writes but I am not sure if that is actually = going to=20 help the issue if fsync=3Doff.

Benjamin = Arai

barai@cs.ucr.edu

http://www.benjaminarai.com

From: = pgsql-performance-owner@postgresql.org=20 [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of = Benjamin=20 Arai
Sent: Wednesday, January 18, 2006 10:10 = AM
To:=20 pgsql-performance@postgresql.org
Subject: [PERFORM] 3WARE = Card=20 performance boost?

Hi,

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

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=20 improvement? If so, what would be a ball park=20 figure?

Benjamin = Arai

barai@cs.ucr.edu

http://www.benjaminarai.com

------=_NextPart_000_0113_01C61C19.A9F98520--