Re: RAID + PostgreSQL? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: RAID + PostgreSQL?
Date
Msg-id 1151423117.4215.66.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: RAID + PostgreSQL?  (Franz.Rasper@izb.de)
List pgsql-general
On Tue, 2006-06-27 at 08:05, Franz.Rasper@izb.de wrote:
> I have here HP DL 380 G3 und HP DL 380 G4. (here Smart Array 5i and Smart
> Array 6i)
> Maybe there are problems with old linux kernel (but as far as i know >
> 2.4.27)
> I dont know about such performance problems, maybe the conrollers are faster
> under windows.
>
> The battery backup write cache are very import for inserts.
>
> You should use for performance test with dd under linux larger blocksizes,
> but you should compare postgresql under linux and windows (selects, update,
> inserts, etc.)

Note that having the latest driver usually helps a lot too.

The LSI megaraid was solid but a mediocre performer with the older 1.18
driver, but the 2.x series driver was much faster when I tested it.

pgsql-general by date:

Previous
From: louis gonzales
Date:
Subject: Re: psql -h host ...
Next
From: Dylan Hansen
Date:
Subject: Re: auto-vacuum & Negative "anl" Values