Subject: Re: Hardware question for a DB server
From: Mark Lewis <mark.lewis@mir3.com>
To: Pascal Cohen <pcohen@wimba.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
In-Reply-To: <47D827EB.3020105@wimba.com>
References: <47D827EB.3020105@wimba.com>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Organization: MIR3, Inc.
Date: Wed, 12 Mar 2008 12:23:41 -0700
Message-Id: <1205349821.9048.1128.camel@archimedes>
Mime-Version: 1.0

What type of usage does it need to scale for?  How many concurrent
connections?  What size database?  Data warehousing or OLTP-type
workloads?  Ratio of reads/writes?  Do you care about losing data?

One question that's likely going to be important depending on your
answers above is whether or not you're getting a battery-backed write
cache for that ServeRAID-8K.

-- Mark Lewis

On Wed, 2008-03-12 at 19:58 +0100, Pascal Cohen wrote:
> Hello, we plan to buy a dedicated server to host our database.
> Here is the proposal I was given (with a second identical server fro 
> backup using log shipping):
> =========================
> IBM X3650 (This is a 2U server, can hold 8 Drives)
> 2 x QC Xeon E5450 (3.0GHz 12MB L2 1333MHz 80W)
> 8 x 2GB RAM (16GB total)
> 2.5" SAS Hotswap
> ServeRAID-8K SAS Controller
> 8 x 73GB 15K 2.5" SAS Drive
> CD/DVD Drive
> Remote Supervisor Adapter II Slimline
> Redundant Power
> 4 Year, 24x7 2hour support/warranty
> 
> =========================
> 
> I would like specialists advices.
> 
> If you need additional details, please let me know.
> 
> Thanks in advance for your help
> 
> Thank you
> 
> Pascal
>