Re: 3WARE Card performance boost?

From: Vivek Khera <vivek(at)khera(dot)org>
To: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 3WARE Card performance boost?
Date: 2006-01-19 21:38:33
Message-ID: 32A67C0F-9726-4E79-AA12-B1D2AD83748A@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tim Jones 2006-01-19 22:20:22 query plans different for 8.1 on windows and aix
Previous Message Andreas Kretschmer 2006-01-19 19:34:26 Re: Stored Procedures