Re: System Requirement - Mailing list pgsql-performance

From hubert depesz lubaczewski
Subject Re: System Requirement
Date
Msg-id 9e4684ce050614013232f9dbbd@mail.gmail.com
Whole thread Raw
In response to System Requirement  (Saranya Sivakumar <sarlavk@yahoo.com>)
List pgsql-performance
On 6/13/05, Saranya Sivakumar <sarlavk@yahoo.com> wrote:
> 2 x 2.4 Ghz Intel Xeon CPU with HT(4 virtual CPUs)

switch to amd opteron (dual cpu). for the same price you get 2x
performance - comparing to xeon boxes.

> RAM - 1GB

you'd definitelly could use more ram. the more the better.

> HDD - 34GB SCSI

is it one drive of 34G? if yes, buy another one and setup raid1 over
them. should boost performance as well.

> Production DB size: 10.89 GB

not much. you could even consider buing 12 or 16g of ram to make it
fit in memory.

depesz

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Updates on large tables are extremely slow
Next
From: Saranya Sivakumar
Date:
Subject: Re: System Requirement