Re: What's the best hardver for PostgreSQL 8.1?

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Benjamin Arai" <barai(at)cs(dot)ucr(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: What's the best hardver for PostgreSQL 8.1?
Date: 2005-12-26 18:50:34
Message-ID: BFD57B7A.1987E%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Benjamin,

On 12/26/05 10:21 AM, "Benjamin Arai" <barai(at)cs(dot)ucr(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Scott 2005-12-26 21:03:34 Performance hit on large row counts
Previous Message Benjamin Arai 2005-12-26 18:21:42 Re: What's the best hardver for PostgreSQL 8.1?