Re: Hardware question for a DB server - Mailing list pgsql-performance

From Mark Lewis
Subject Re: Hardware question for a DB server
Date
Msg-id 1205349821.9048.1128.camel@archimedes
Whole thread Raw
In response to Hardware question for a DB server  (Pascal Cohen <pcohen@wimba.com>)
Responses Re: Hardware question for a DB server
Re: Hardware question for a DB server
List 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
>

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
Next
From: Pascal Cohen
Date:
Subject: Re: Hardware question for a DB server