Re: RAID controllers for Postgresql on large setups - Mailing list pgsql-performance

From Vivek Khera
Subject Re: RAID controllers for Postgresql on large setups
Date
Msg-id E40D6F6C-BF91-4464-8A1D-857F6EB611A2@khera.org
Whole thread Raw
In response to RAID controllers for Postgresql on large setups  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-performance
On May 12, 2008, at 10:04 PM, Francisco Reyes wrote:

> Adaptec 2120 SCSI controller (64MB of cache).
>
> The servers have mostly have 12 drives in RAID 10.
> We are going to redo one machine to compare  RAID 10 vs RAID 50.
> Mostly to see if the perfomance is close, the space gain may be
> usefull.

with only 64Mb of cache, you will see degradation of performance.
from my experience, the adaptec controllers are not the best choice,
but that's mostly FreeBSD experience.  And if you don't have a BBU,
you're not benefitting from the write-back cache at all so it is kind
of moot.

If you want to buy a couple of 2230SLP cards with 256Mb of RAM, I have
them for sale.  They're identical to the 2130SLP but have two SCSI
channels per card instead of one.  they both have BBUs, and are in
working condition.  I retired them in favor of an external RAID
attached via Fibre Channel.


pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Installation Steps to migrate to Postgres 8.3.1
Next
From: Vivek Khera
Date:
Subject: Re: RAID controllers for Postgresql on large setups