User-Agent: Microsoft-Entourage/11.2.1.051004
Date: Mon, 26 Dec 2005 10:50:34 -0800
Subject: Re: What's the best hardver for PostgreSQL 8.1?
From: "Luke Lonergan" <llonergan@greenplum.com>
To: "Benjamin Arai" <barai@cs.ucr.edu>
cc: pgsql-performance@postgresql.org
Message-ID: <BFD57B7A.1987E%llonergan@greenplum.com>
Thread-Topic: [PERFORM] What's the best hardver for PostgreSQL 8.1?
Thread-Index: AcYKSVBWxlHzGlidTweIB31sFsrM+gAA/BOH
In-Reply-To: <43B034B6.7070708@cs.ucr.edu>
MIME-Version: 1.0
Content-Type: text/plain;
 charset=us-ascii
Content-Transfer-Encoding: 7bit

Benjamin,

On 12/26/05 10:21 AM, "Benjamin Arai" <barai@cs.ucr.edu> wrote:

> Have you have any experience rebuilding arrays in linux using the 3Ware
> utilities?  If so, did it work well?

Sure we have - nowadays with disks failing as much as they do how could we
not? ;-)

3Ware has some *nice* tools - including a web browser utility for managing
the RAID.  Rebuilds have been super easy - and the e-mail notification is
fine.  They even have some decent migration options.

What they don't have are tools like snapshot backup, like EMC has, or SRDF
or any of the enterprise SAN features.  We don't need them because Bizgres
MPP takes care of the need in software, but some people have become
accustomed to the features for other uses.

We're pretty happy with 3Ware, but their new 9550SX is, well, new.  We
managed to find a good enough combination of driver and firmware to make it
work well on CentOs 4.1 and that's good enough for us, but there are
definitely some issues with some combinations now.  Lastly, you do have to
set the block device readahead to 16MB to get performance.

- Luke