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

Re: RAID card recommendation

From: Jochen Erwied <jochen(at)pgsql-performance(dot)erwied(dot)eu>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: RAID card recommendation
Date: 2009-11-24 19:28:04
Message-ID: 13210234982.20091124202804@erwied.eu (view raw or flat)
Thread:
Lists: pgsql-performance
Since I'm currently looking at upgrading my own database server, maybe some
of the experts can give a comment on one of the following controllers:

- Promise Technology Supertrak ES4650 + additional BBU
- Adaptec RAID 5405 SGL/256 SATA/SAS + additional BBU
- Adaptec RAID 5405Z SGL/512 SATA/SAS

My personal favourite currently is the 5405Z, since it does not require 
regular battery replacements and because it has 512MB of cache.

Since my server only has room for four disks, I'd choose the following
one:

- Seagate Cheetah 15K.6 147GB SAS

Drives would be organized as RAID-0 for fast access, I do not need 
terabytes of storage.

The database currently is about 150 GB in size (including indexes), the
main table having a bit less than 1 billion rows (maximum will be about 2
billion) and getting about 10-20 million updates per day, so update speed
is critical.

Currently the database is running on a mdadm raid-0 with four S-ATA drives 
(7.2k rpm), which was ok when the database was half this size...

Operating System is Gentoo Linux 2.6.31-r1 on a Fujitsu Siemens Primergy
200 S2 (2xXEON @ 1.6 GHz) with 4 GB of RAM (which also would be increased
to its maximum of 8 GB during the above update)


-- 
Jochen Erwied     |   home: jochen(at)erwied(dot)eu     +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |   work: joe(at)mbs-software(dot)de  +49-2151-7294-24, FAX: -50
D-45470 Muelheim  | mobile: jochen(dot)erwied(at)vodafone(dot)de       +49-173-5404164


In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2009-11-24 20:05:28
Subject: Re: RAID card recommendation
Previous:From: Scott MarloweDate: 2009-11-24 19:13:03
Subject: Re: RAID card recommendation

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