Message-ID: <47D83241.6080009@wimba.com>
Date: Wed, 12 Mar 2008 20:42:57 +0100
From: Pascal Cohen <pcohen@wimba.com>
User-Agent: Thunderbird 2.0.0.12 (X11/20080226)
MIME-Version: 1.0
CC: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Hardware question for a DB server
References: <47D827EB.3020105@wimba.com>
	<1205349821.9048.1128.camel@archimedes>
In-Reply-To: <1205349821.9048.1128.camel@archimedes>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Mark Lewis wrote:
> 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?
>   
I expected those questions but I was sure that I would forget or ignore 
some ;)
- This Database will be accessed by Web applications but also by an XMPP 
server. This means that those are not complex requests but we may have a 
number of high parallel requests for small results. Ideally as many 
connections as possible would be nice.
- I am not sure but I would say from what I found thanks to Google is 
that we are probably closer to an OLTP type workload (but I may be wrong)
- Size of the DB: a few Gb but not yet more than the 16Gb.
- It is a read mainly database (8/9 reads for 1 write) with potential 
batch updates
- We cannot afford (anymore) 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
>>
>>     
>
>