Re: Hardware question for a DB server

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Pascal Cohen <pcohen(at)wimba(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Hardware question for a DB server
Date: 2008-03-12 19:23:41
Message-ID: 1205349821.9048.1128.camel@archimedes
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pascal Cohen 2008-03-12 19:42:57 Re: Hardware question for a DB server
Previous Message Bruce Momjian 2008-03-12 19:16:39 Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1