Re: Tuning PostgreSQL - Mailing list pgsql-performance

From Will LaShell
Subject Re: Tuning PostgreSQL
Date
Msg-id 1059495404.24884.69.camel@lyric.ofsloans.com
Whole thread Raw
In response to Re: Tuning PostgreSQL  (Vivek Khera <khera@kcilink.com>)
List pgsql-performance
On Tue, 2003-07-29 at 08:14, Vivek Khera wrote:
> >>>>> "GS" == Greg Stark <gsstark@mit.edu> writes:
>
> GS> "scott.marlowe" <scott.marlowe@ihs.com> writes:
>
> GS> But you have to actually test your setup in practice to see if it
> GS> hurts. A big data warehousing system will be faster under RAID5
> GS> than under RAID1+0 because of the extra disks in the
> GS> stripeset. The more disks in the stripeset the more bandwidth you
> GS> get.
>
> Anyone have ideas on 14 spindles?  I just ordered a disk subsystem
> with 14 high speed (U320 15kRPM) SCSI disks to hook up with a dell
> PERC3/DC controller (only 128MB cache, though).
<SNIP>

Hey one comment on this. With dell Perc3/DC  you should check the
megaraid-devel list to find the best BIOS settings for maximum
performance.  There have been many comments on it and trials to get it
going really well.  All told though I totally love the LSI Megaraid (
which is what the perc3/dc is ) controllers. We use the Elite 1650  with
seagate cheetah drives for a nice little array.

--Will

Attachment

pgsql-performance by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Tuning PostgreSQL
Next
From: "scott.marlowe"
Date:
Subject: Re: Tuning PostgreSQL