Re: Huge Data sets, simple queries - Mailing list pgsql-performance

From Michael Stone
Subject Re: Huge Data sets, simple queries
Date
Msg-id 20060129154323.GA9976@mathom.us
Whole thread Raw
In response to Re: Huge Data sets, simple queries  (hubert depesz lubaczewski <depesz@gmail.com>)
List pgsql-performance
On Sun, Jan 29, 2006 at 12:25:23PM +0100, hubert depesz lubaczewski wrote:
>hmm .. do i understand correctly that you're suggesting that using
>raid 10 and/or hardware raid adapter might hurt disc subsystem
>performance? could you elaborate on the reasons, please?

I think it's been fairly well beaten to death that the low-end hardware
raid adapters have lousy performance. It's not until you get into the
range of battery-backed disk caches with 512M+ and multiple I/O channels
that hardware raid becomes competitive with software raid.

Mike Stone

pgsql-performance by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Huge Data sets, simple queries
Next
From: "Luke Lonergan"
Date:
Subject: Re: Huge Data sets, simple queries