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:[EMAIL PROTECTED] Gesendet: Dienstag, 27. Juni 2006 17:45 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; pgsql general Betreff: Re: [GENERAL] RAID + PostgreSQL? On Tue, 2006-06-27 at 08:05, [EMAIL PROTECTED] 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
