From: | Alex Turner <armtuk(at)gmail(dot)com> |
---|---|
To: | William Yu <wyu(at)talisys(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: 3WARE Card performance boost? |
Date: | 2006-01-19 22:54:32 |
Message-ID: | 33c6269f0601191454u65191b61vcd105256db94a78d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)talisys(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2006-01-19 23:10:32 | Re: Autovacuum / full vacuum (off-topic?) |
Previous Message | Bruce Momjian | 2006-01-19 22:52:14 | Re: Stable function being evaluated more than once in a single |