Re: What's the best hardver for PostgreSQL 8.1? - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: What's the best hardver for PostgreSQL 8.1?
Date
Msg-id 20051225151543.GB11637@wolff.to
Whole thread Raw
In response to Re: What's the best hardver for PostgreSQL 8.1?  ("Luke Lonergan" <LLonergan@greenplum.com>)
List pgsql-performance
On Sat, Dec 24, 2005 at 22:13:43 -0500,
  Luke Lonergan <LLonergan@greenplum.com> wrote:
> David,
>
> > now hot-swap may not be supported on all interface types, that may be what
> > you have run into, but with SCSI or SATA you should be able to hot-swap
> > with the right controller.
>
> That's actually the problem - Linux hot swap is virtually non-functional for SCSI.  You can write into the proper
placesin /proc, then remove and rescan to get a new drive up, but I've found that the resulting OS state is flaky.
Thisis true of the latest 2.6 kernels and LSI and Adaptec SCSI controllers. 
>
> The problems I've seen are  with Linux, not the controllers.

The other option is to keep hot spares available so that you can have a failure
or two before you have to pull drives out. This might allow you to get to a
maintenance window to swap out the bad drives.

pgsql-performance by date:

Previous
From: "Steinar H. Gunderson"
Date:
Subject: Re: What's the best hardver for PostgreSQL 8.1?
Next
From: Michael Stone
Date:
Subject: Re: What's the best hardver for PostgreSQL 8.1?