From: William Yu <wyu@talisys.com>
To: pgsql-performance@postgresql.org
Subject: Re: 3WARE Card performance boost?
Date: Wed, 18 Jan 2006 13:58:09 -0800
Message-ID: <dqmdli$2qjl$1@news.hub.org> (raw)
In-Reply-To: <00ee01c61c5a$5db2c870$d7cc178a@uni>
References: <00ee01c61c5a$5db2c870$d7cc178a@uni>
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 current software RAID 1 configuration, am I going to see a
> very large improvement? If so, what would be a ball park figure?
The key is getting a card with the ability to upgrade the onboard ram.
Our previous setup was a LSI MegaRAID 320-1 (128MB), 4xRAID10,
fsync=off. Replaced it with a ARC-1170 (1GB) w/ 24x7200RPM SATA2 drives
(split into 3 8-drive RAID6 arrays) and performance for us is through
the ceiling.
For OLTP type updates, we've gotten about +80% increase. For massive
1-statement updates, performance increase is in the +triple digits.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wyu@talisys.com
Subject: Re: 3WARE Card performance boost?
In-Reply-To: <dqmdli$2qjl$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox