Re: Data write speed

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Murthy Kambhampaty <murthy(dot)kambhampaty(at)goeci(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Data write speed
Date: 2003-02-27 17:54:49
Message-ID: Pine.LNX.4.33.0302271052200.19991-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 27 Feb 2003, Josh Berkus wrote:

> Murthy,
>
> > You could get mondo (http://www.microwerks.net/~hugo/), then backup your
> > system to CDs and restore it with the new filesystem layout. You might want
> > to do these backups as a matter of course?
>
> Thanks for the suggestion. The problem isn't backup media ... we have a DLT
> drive ... the problem is time. This particular application is already about
> 4 weeks behind schedule because of various hardware problems. At some point,
> Kevin Brown and I will take a weekend to swap the postgres files to a spare
> disk, and re-format the data array as pass-through Linux RAID.
>
> And this is the last time I leave it up to the company sysadmin to buy
> hardware for a database server, even with explicit instructions ... "Yes, I
> saw which one you wanted, but the 2200S was on sale!"

I still remember going round and round with a hardware engineer who was
extolling the adaptec AIC 133 controller as a great raid controller. I
finally made him test it instead of just reading the pamphlet that came
with it... Needless to say, it couldn't hold it's own against a straight
symbios UW card running linux software RAID.

He's the same guy who speced my workstation with no AGP slot in it. The
week before he was laid off. Talk about bad timing... :-(

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message philip johnson 2003-02-27 18:51:01 Re: [Performance] Daily Crash
Previous Message Josh Berkus 2003-02-27 16:57:32 Re: Data write speed