From: Pascal Cohen <pcohen@wimba.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Hardware question for a DB server
Date: Wed, 12 Mar 2008 20:42:57 +0100
Message-ID: <47D83241.6080009@wimba.com> (raw)
In-Reply-To: <1205349821.9048.1128.camel@archimedes>
References: <47D827EB.3020105@wimba.com>
<1205349821.9048.1128.camel@archimedes>
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
>>
>>
>
>
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: pcohen@wimba.com
Subject: Re: Hardware question for a DB server
In-Reply-To: <47D83241.6080009@wimba.com>
* 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