Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group