From: Andrew G. Hammond <drew@xyzzy.dhs.org>
To: Jeff Bohmer <bohmer@visionlink.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware suggestions for Linux/PGSQL server
Date: Sun, 14 Dec 2003 23:17:19 -0500
Message-ID: <3FDD35CF.6080103@xyzzy.dhs.org> (raw)
In-Reply-To: <p04330103bc0148b6ebfe@[192.168.1.201]>
References: <Pine.LNX.4.33.0312111548100.16283-100000@css120.ihs.com>
<p04330103bc0148b6ebfe@[192.168.1.201]>
I don't know what your budget is, but there are now 10k RPM SATA 150
drives on the market. Their price/performance is impressive. You may
want to consider going with a bunch of these instead of SCSI disks (more
spindles vs. faster spindles). 3ware makes a hardware raid card that can
drive up to 12 SATA disks. I have been told by a few people who have
used it that the linux driver is very solid.
Drew
Jeff Bohmer wrote:
>> Just one more piece of advice, you might want to look into a good
>> battery
>> backed cache hardware RAID controller. They work quite well for heavily
>> updated databases. The more drives you throw at the RAID array the
>> faster
>> it will be.
>
>
> I've seen this list often recommended such a setup. We'll probably
> get battery-backed write cache and start out with a 4 disk RAID 10
> array. Then add more disks and change RAID 5 if more read performance
> is needed.
>
> Thanks,
> - Jeff
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: drew@xyzzy.dhs.org, bohmer@visionlink.org
Subject: Re: Hardware suggestions for Linux/PGSQL server
In-Reply-To: <3FDD35CF.6080103@xyzzy.dhs.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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