Skip site navigation (1) Skip section navigation (2)

Re: 3WARE Card performance boost?

From: "Benjamin Arai" <barai(at)cs(dot)ucr(dot)edu>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 3WARE Card performance boost?
Date: 2006-01-18 18:26:37
Message-ID: 011201c61c5c$b81cc520$d7cc178a@uni (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)cs(dot)ucr(dot)edu
http://www.benjaminarai.com <http://www.benjaminarai.com/> 
 


  _____  

From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Benjamin Arai
Sent: Wednesday, January 18, 2006 10:10 AM
To: pgsql-performance(at)postgresql(dot)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(at)cs(dot)ucr(dot)edu
http://www.benjaminarai.com <http://www.benjaminarai.com/> 
 

In response to

Responses

pgsql-performance by date

Next:From: Michael AdlerDate: 2006-01-18 18:54:16
Subject: Re: SAN/NAS options
Previous:From: Joshua D. DrakeDate: 2006-01-18 18:24:17
Subject: Re: 3WARE Card performance boost?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group