Re: Huge Data sets, simple queries

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Huge Data sets, simple queries
Date: 2006-01-29 15:43:24
Message-ID: 20060129154323.GA9976@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2006-01-29 18:44:08 Re: Huge Data sets, simple queries
Previous Message hubert depesz lubaczewski 2006-01-29 11:25:23 Re: Huge Data sets, simple queries