Re: 3WARE Card performance boost?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
 


From: pgsql-performance-owner@xxxxxxxxxxxxxx [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] On Behalf Of Benjamin Arai
Sent: Wednesday, January 18, 2006 10:10 AM
To: pgsql-performance@xxxxxxxxxxxxxx
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
 

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux