Skip site navigation (1) Skip section navigation (2)

Re: Hardware: HP StorageWorks MSA 1500

From: "mlartz(at)gmail(dot)com" <mlartz(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware: HP StorageWorks MSA 1500
Date: 2006-04-26 01:42:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
I'd be interested in those numbers once you get them, especially for
ext3.  We just picked up an HP MSA1500cs with the MSA50 sled, and I am
curious as to how best to configure it for Postgres.  My server is the
HP DL585 (quad, dual-core Opteron, 16GB RAM) with 4 HD bays run by a HP
SmartArray 5i controller.  I have 15 10K 300GB drives and 1 15K 150GB
drive (don't ask how that happened).

The database is going to be very datawarehouse-ish (bulk loads, lots of
queries) and has the potential to grow very large (1+ TB).  Plus, with
that much data, actual backups won't be easy, so I'll be relying on
RAID+watchfullness to keep me safe, at least through the prototype

How would/do you guys set up your MSA1x00 with 1 drive sled?  RAID10 vs
RAID5 across 10+ disks?  Here's what I was thinking (ext3 across

Direct attached:
  2x300GB RAID10 - OS + ETL staging area
  2x300GB RAID10 - log + indexes
  10x300GB RAID10 + 1x300GB hot spare - tablespace

I'm not quite sure what to do with the 15K/150GB drive, since it is a
singleton.  I'm also planning on giving all the 256MB MSA1500 cache to
reads, although I might change it for the batch loads to see if it
speeds things up.

Also, unfortunately, the MSA1500 only has a single SCSI bus, which
could significantly impact throughput, but we got a discount, so
hopefully we can get another bus module in the near future and pop it

Any comments are appreciated,

In response to

pgsql-performance by date

Next:From: Leigh DyerDate: 2006-04-26 01:53:06
Subject: Re: Large (8M) cache vs. dual-core CPUs
Previous:From: chris smithDate: 2006-04-26 01:39:41
Subject: Re: Query on postgresql 7.4.2 not using index

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group