pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
hp ciss on freebsd
4+ messages / 4 participants
[nested] [flat]

* hp ciss on freebsd
@ 2007-11-05 13:19  Claus Guttesen <kometen@gmail.com>
  0 siblings, 3 replies; 4+ messages in thread

From: Claus Guttesen @ 2007-11-05 13:19 UTC (permalink / raw)
  To: pgsql-performance

Hi.

We are using a HP DL 380 G5 with 4 sas-disks at 10K rpm. The
controller is a built in ciss-controller with 256 MB battery-backed
cache. It is partitioned as raid 1+0.

Our queries are mainly selects.

I will get four 72 GB sas-disks at 15K rpm. Reading the archives
suggest raid 1+0 for optimal read/write performance, but with a solid
raid-controller raid 5 will also perform very well when reading.

Is the ciss-controller found in HP-servers a "better" raid-controller
compared to the areca-raid-controller mentioned on this list?

-- 
regards
Claus

When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.

Shakespeare



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

* Re: hp ciss on freebsd
@ 2007-11-05 15:47  Jeff Trout <threshar@torgo.978.org>
  parent: Claus Guttesen <kometen@gmail.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Jeff Trout @ 2007-11-05 15:47 UTC (permalink / raw)
  To: Claus Guttesen <kometen@gmail.com>; +Cc: pgsql-performance


On Nov 5, 2007, at 8:19 AM, Claus Guttesen wrote:

>
> Is the ciss-controller found in HP-servers a "better" raid-controller
> compared to the areca-raid-controller mentioned on this list?
>

I've had great success with the P600 controller (upgraded to 512MB  
bbwc) plugged into an MSA70 with a pile of SAS disks.  I'm using R6  
(ADG) and getting some crazy good numbers with it.

My newest box has a built-in p400, that did ok, but not as good as  
the p600.  HP also has the P800 available as well.

Your best bet is to load up some data, and do some testing.  Check  
out the pgiosim project on pgfoundry, it sort of simulates a pg index  
scan, which is probably what you'll want to focus on more than seq  
read speed.


--
Jeff Trout <jeff@jefftrout.com>
http://www.dellsmartexitin.com/
http://www.stuarthamm.net/






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

* Re: hp ciss on freebsd
@ 2007-11-05 16:32  Greg Smith <gsmith@gregsmith.com>
  parent: Claus Guttesen <kometen@gmail.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Greg Smith @ 2007-11-05 16:32 UTC (permalink / raw)
  To: Claus Guttesen <kometen@gmail.com>; +Cc: pgsql-performance

On Mon, 5 Nov 2007, Claus Guttesen wrote:

> Is the ciss-controller found in HP-servers a "better" raid-controller
> compared to the areca-raid-controller mentioned on this list?

If you search the archives for "cciss" you'll see a few complaints about 
this controller not working all that well under Linux.  The smart thing to 
do regardless of what other people say is to test yourself and see if 
you're meeting expectations.  I've got a sample of how a single disk 
performs with an Areca controller you can use as a baseline at 
http://www.westnet.com/~gsmith/content/postgresql/pg-disktesting.htm

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD



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

* Re: hp ciss on freebsd
@ 2007-11-08 16:37  Vivek Khera <khera@kcilink.com>
  parent: Claus Guttesen <kometen@gmail.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Vivek Khera @ 2007-11-08 16:37 UTC (permalink / raw)
  To: pgsql-performance


On Nov 5, 2007, at 8:19 AM, Claus Guttesen wrote:

> I will get four 72 GB sas-disks at 15K rpm. Reading the archives
> suggest raid 1+0 for optimal read/write performance, but with a solid
> raid-controller raid 5 will also perform very well when reading.

If you only have 4 drives, I'd recommend not to go with RAID5. You  
want to max out spindles.  The 256k RAM may not be enough of a cache  
too.




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


end of thread, other threads:[~2007-11-08 16:37 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-05 13:19 hp ciss on freebsd Claus Guttesen <kometen@gmail.com>
2007-11-05 15:47 ` Jeff Trout <threshar@torgo.978.org>
2007-11-05 16:32 ` Greg Smith <gsmith@gregsmith.com>
2007-11-08 16:37 ` Vivek Khera <khera@kcilink.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