Re: Hardware recommendation: which is best

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Hardware recommendation: which is best
Date: 2007-09-11 15:24:19
Message-ID: Pine.GSO.4.64.0709111114120.24969@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 11 Sep 2007, Phoenix Kiula wrote:

> I'll have a raid controller in both scenarios, but which RAID should
> be better: RAID1 or RAID10?

The point people are trying to make to you is that the differences between
RAID controllers can be as big as that between RAID architectures in cases
like yours. Which controller you're using and how the cache is setup can
have a larger impact on INSERT performance than how many/what type of
disks are involved. If you've comparing a fast SAS controller to a slow
SATA2 one, than the SAS setup may very well run faster no matter how many
disks the SATA2 one has. Conversely, it's not unheard of to have a SAS
controller with such miserable operating system drivers that there is no
performance advantage to using faster SCSI disks instead of SATA2.

You're not going to get a particularly useful answer here without giving
some specifics about the two disk controllers you're comparing, how much
cache they have, and whether they include a battery backup.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George Pavlov 2007-09-11 15:50:02 creating/dropping tables inside functions?
Previous Message Phoenix Kiula 2007-09-11 15:00:42 Re: Partial index with regexp not working