pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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






view thread (12+ messages)  latest in thread

Message-ID: <3FDD35CF.6080103@xyzzy.dhs.org>
Permalink:  ../3FDD35CF.6080103@xyzzy.dhs.org/
Also on:    postgresql.org/message-id/3FDD35CF.6080103@xyzzy.dhs.org

 · 

reply

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