Re: 3WARE Card performance boost? - Mailing list pgsql-performance

From Vivek Khera
Subject Re: 3WARE Card performance boost?
Date
Msg-id 32A67C0F-9726-4E79-AA12-B1D2AD83748A@khera.org
Whole thread Raw
In response to 3WARE Card performance boost?  ("Benjamin Arai" <barai@cs.ucr.edu>)
List pgsql-performance
On Jan 18, 2006, at 1:09 PM, Benjamin Arai 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

I'll bet that if you increase your checkpoint_segments (and
corresponding timeout value) to something in the 10's or higher it
will help you a lot.


pgsql-performance by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Stored Procedures
Next
From: "Tim Jones"
Date:
Subject: query plans different for 8.1 on windows and aix