pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: OT: Help with performance problems
2+ messages / 2 participants
[nested] [flat]

* Re: OT: Help with performance problems
@ 2004-04-26 09:01  Rob Fielding <rob@dsvr.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Rob Fielding @ 2004-04-26 09:01 UTC (permalink / raw)
  To: pgsql-performance

scott.marlowe wrote:
> On Fri, 23 Apr 2004, Chris Hoover wrote:
> 
> 
>>DB's on Powervaults 220S using raid 5 (over 6 disks)
> 
> 
> What controller is this, the adaptec?  We've found it to be slower than 
> the LSI megaraid based controller, but YMMV.

Wow, really? You got any more details of the chipset, mobo and kernel 
driver ?

I've been taken to my wits end wrestling with an LSI MegaRAID 320-1 
controller on a supermicro board all weekend. I just couldn't get 
anything more than 10MB/sec out of it with megaraid driver v1 OR v2 in 
Linux 2.4.26, nor the version in 2.6.6-rc2. After 2 days of humming the 
Adaptec mantra I gave in and switched the array straight onto the 
onboard Adaptec 160 controller (same cable and everything). Software 
RAID 5 gets me over 40MB sec for a nominal cpu hit - more than 4 times 
what I could get out of the MegaRAID controller :( Even the 2nd SCSI-2 
channel gets 40MB/sec max (pg_xlog :)

And HOW LONG does it take to detect drives during POST....ohhhh never 
mind ... I really just wanna rant :) There should be a free counseling 
service for enraged sysops.

-- 

Rob Fielding
rob@dsvr.net

www.dsvr.co.uk              Development             Designer Servers Ltd



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: OT: Help with performance problems
@ 2004-04-27 18:02  scott.marlowe <scott.marlowe@ihs.com>
  parent: Rob Fielding <rob@dsvr.net>
  0 siblings, 0 replies; 2+ messages in thread

From: scott.marlowe @ 2004-04-27 18:02 UTC (permalink / raw)
  To: Rob Fielding <rob@dsvr.net>; +Cc: pgsql-performance

On Mon, 26 Apr 2004, Rob Fielding wrote:

> scott.marlowe wrote:
> > On Fri, 23 Apr 2004, Chris Hoover wrote:
> > 
> > 
> >>DB's on Powervaults 220S using raid 5 (over 6 disks)
> > 
> > 
> > What controller is this, the adaptec?  We've found it to be slower than 
> > the LSI megaraid based controller, but YMMV.
> 
> Wow, really? You got any more details of the chipset, mobo and kernel 
> driver ?

We're running on a Dell 2650, the controller is the U320 LSI megaraid 2 
channel (they only make the one that I know of right now).  Don't know my 
mobo chipset offhand, but might be able to find out what one dell includes 
on the 2650.  The kernel driver is the latest megaraid2 driver as of about 
Feb this year.

> I've been taken to my wits end wrestling with an LSI MegaRAID 320-1 
> controller on a supermicro board all weekend. I just couldn't get 
> anything more than 10MB/sec out of it with megaraid driver v1 OR v2 in 
> Linux 2.4.26, nor the version in 2.6.6-rc2. After 2 days of humming the 
> Adaptec mantra I gave in and switched the array straight onto the 
> onboard Adaptec 160 controller (same cable and everything). Software 
> RAID 5 gets me over 40MB sec for a nominal cpu hit - more than 4 times 
> what I could get out of the MegaRAID controller :( Even the 2nd SCSI-2 
> channel gets 40MB/sec max (pg_xlog :)
> 
> And HOW LONG does it take to detect drives during POST....ohhhh never 
> mind ... I really just wanna rant :) There should be a free counseling 
> service for enraged sysops.

I wonder if your controller is broken or something?  Or maybe on a PCI 
slow that has to share IRQs or something.  I've had great luck with 
SuperMicro mobos in the past (we're talking dual PPro 200 mobos, so 
seriously, IN THE PAST here... )  Hell, my Dual PPro 200 with an old 
MegaRAID 428 got 18 Megs a second cfer rate no problem.

Have you tried that lsi card in another machine / mobo combo?  Can you 
disable the onboard adaptec?  We have on our Dell 2650s, the only active 
controllers are the onboard IDE and the add in LSI-320-2 controller.

We're running ours with 128 Meg cache (I think could be 64) set to write 
back.  I think our throughput on a RAID-1 pair was somewhere around 40+ 
megs a second reads with bonnie++  With RAID-5 it was not really much 
faster at reads (something like 60 megs a second) but was much more 
scalable under heavy parellel read/write access for PostgreSQL.

Have you updated the BIOS on the mobo to see if that helps?  I'm just 
throwing darts at the wall here.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-04-27 18:02 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-26 09:01 Re: OT: Help with performance problems Rob Fielding <rob@dsvr.net>
2004-04-27 18:02 ` scott.marlowe <scott.marlowe@ihs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox