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

From hubert depesz lubaczewski
Subject Re: Huge Data sets, simple queries
Date
Msg-id 9e4684ce0601290325p4f284c57ndeaae13e6ce58fd7@mail.gmail.com
Whole thread Raw
In response to Re: Huge Data sets, simple queries  ("Luke Lonergan" <llonergan@greenplum.com>)
Responses Re: Huge Data sets, simple queries  (Michael Stone <mstone+postgres@mathom.us>)
List pgsql-performance
On 1/28/06, Luke Lonergan <llonergan@greenplum.com> wrote:
> You should check your disk performance, I would
> expect you'll find it lacking, partly because you are running RAID10, but
> mostly because I expect you are using a hardware RAID adapter.

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? it's not that
i'm against the idea - i'm just curious as this is very
"against-common-sense". and i always found it interesting when
somebody states something that uncommon...

best regards

depesz

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Huge Data sets, simple queries
Next
From: Michael Stone
Date:
Subject: Re: Huge Data sets, simple queries