Alex
On 6/28/06, Franz.Rasper@xxxxxx <Franz.Rasper@xxxxxx> wrote:
How much I/O Performance do you need ?
READ Performance ? Write Performance ?
I need an fast and reliable RAID Controller (harddisks have to be hot plug,
automatic rebuild etc.)
and I have to say that the HP DL 380 G 4 with Battery Backup Write Cache ,
FAST U320 HDs,
some gigs ram (chipkill is a nice feature), redundant fans and power
supplies is a good database server.
Unfortunately I had no chance to test the HP DL 385.
Greetings,
-Franz
-----Ursprüngliche Nachricht-----
Von: Scott Marlowe [mailto: smarlowe@xxxxxxxxxxxxxxxxx]
Gesendet: Dienstag, 27. Juni 2006 17:45
An: Franz.Rasper@xxxxxx
Cc: teolupus@xxxxxxxxx; pgsql general
Betreff: Re: [GENERAL] RAID + PostgreSQL?
On Tue, 2006-06-27 at 08:05, Franz.Rasper@xxxxxx 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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
