Re: Hardware spec - Mailing list pgsql-performance

From Decibel!
Subject Re: Hardware spec
Date
Msg-id 20070911203554.GZ38801@decibel.org
Whole thread Raw
In response to Re: Hardware spec  (Willo van der Merwe <willo@mirasol.co.za>)
Responses Re: Hardware spec
List pgsql-performance
On Thu, Sep 06, 2007 at 11:26:46AM +0200, Willo van der Merwe wrote:
> Richard Huxton wrote:
> >Willo van der Merwe wrote:
> >>Hi guys,
> >>
> >>I'm have the rare opportunity to spec the hardware for a new database
> >>server. It's going to replace an older one, driving a social networking
> >>web application. The current server (a quad opteron with 4Gb of RAM and
> >>80Gb fast SCSI RAID10) is coping with an average load of ranging between
> >>1.5 and 3.5.
> >>
> >>The new machine spec I have so far:
> >What's the limiting factor on your current machine - disk, memory, cpup?
> I'm a bit embarrassed to admit that I'm not sure. The reason we're
> changing machines is that we might be changing ISPs and we're renting /
> leasing the machines from the ISP.

Get yourself the ability to benchmark your application. This is
invaluable^W a requirement for any kind of performance tuning.
--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Attachment

pgsql-performance by date:

Previous
From: Decibel!
Date:
Subject: Re: Performance on 8CPU's and 32GB of RAM
Next
From: Decibel!
Date:
Subject: Re: SAN vs Internal Disks