Re: Hardware advice - Mailing list pgsql-performance

From Will LaShell
Subject Re: Hardware advice
Date
Msg-id 1054322103.15469.8.camel@lyric.ofsloans.com
Whole thread Raw
In response to Re: Hardware advice  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: Hardware advice
List pgsql-performance
On Fri, 2003-05-30 at 07:44, Andrew Sullivan wrote:
> On Fri, May 30, 2003 at 03:23:28PM +0100, Adam Witney wrote:
> > RAID5 for 3x 146Gb drives
>
> I find the RAID5 on the PERC to be painfully slow.  It's _really_ bad
> if you don't put WAL on its own drive.

This seems to be an issue with the dell firmware.  The megaraid devel
list has been tracking this issue on and off for some time now.  People
have had good luck with a couple of different fixes. The PERC cards
-can- be made not to suck and the LSI cards simply don't have the
problem. ( Since they are effectively the same card its the opinion that
its the firmware )



> Also, you don't mention it, but check to make sure you're getting ECC
> memory on these boxes.  Random memory errors which go undetected will
> make you very unhappy.  ECC lowers (but doesn't eliminate,
> apparently) your chances.

100% agree with this note.

> A
>
> --
> ----
> Andrew Sullivan                         204-4141 Yonge Street
> Liberty RMS                           Toronto, Ontario Canada
> <andrew@libertyrms.info>                              M2P 2A8
>                                          +1 416 646 3304 x110
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


Attachment

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Table Relationships
Next
From: "scott.marlowe"
Date:
Subject: Re: Hardware advice