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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Luke Lonergan <LLonergan(at)greenplum(dot)com>
Cc: David Lang <dlang(at)invendra(dot)net>, Frank Wiles <frank(at)wiles(dot)org>, Juan Casero <caseroj(at)comcast(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: What's the best hardver for PostgreSQL 8.1?
Date: 2005-12-25 15:15:43
Message-ID: 20051225151543.GB11637@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Dec 24, 2005 at 22:13:43 -0500,
Luke Lonergan <LLonergan(at)greenplum(dot)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 places in /proc, then remove and rescan to get a new drive up, but I've found that the resulting OS state is flaky. This is 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Stone 2005-12-25 17:37:55 Re: What's the best hardver for PostgreSQL 8.1?
Previous Message Steinar H. Gunderson 2005-12-25 12:29:19 Re: What's the best hardver for PostgreSQL 8.1?