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@xxxxxxxxx +49-208-38800-18, FAX: -19 Sauerbruchstr. 17 | work: joe@xxxxxxxxxxxxxxx +49-2151-7294-24, FAX: -50 D-45470 Muelheim | mobile: jochen.erwied@xxxxxxxxxxx +49-173-5404164 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
