From: Alex Turner <armtuk@gmail.com>
To: William Yu <wyu@talisys.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: 3WARE Card performance boost?
Date: Thu, 19 Jan 2006 17:54:32 -0500
Message-ID: <33c6269f0601191454u65191b61vcd105256db94a78d@mail.gmail.com> (raw)
In-Reply-To: <dqmdli$2qjl$1@news.hub.org>
References: <00ee01c61c5a$5db2c870$d7cc178a@uni>
<dqmdli$2qjl$1@news.hub.org>
He's talking about RAID 1 here, not a gargantuan RAID 6. Onboard RAM
on the controller card is going to make very little difference. All
it will do is allow the card to re-order writes to a point (not all
cards even do this).
Alex.
On 1/18/06, William Yu <wyu@talisys.com> wrote:
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
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: armtuk@gmail.com, wyu@talisys.com
Subject: Re: 3WARE Card performance boost?
In-Reply-To: <33c6269f0601191454u65191b61vcd105256db94a78d@mail.gmail.com>
* 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