Re: Hardware spec - Mailing list pgsql-performance

From Willo van der Merwe
Subject Re: Hardware spec
Date
Msg-id 46E78EBE.8050501@mirasol.co.za
Whole thread Raw
In response to Re: Hardware spec  (Decibel! <decibel@decibel.org>)
Responses Re: Hardware spec  ("Claus Guttesen" <kometen@gmail.com>)
List pgsql-performance
Decibel! wrote:
> 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.
>
I'm pretty happy with the performance of the database at this stage.
Correct me if I'm wrong, but AFAIK a load of 3.5 on a quad is not
overloading it. It also seem to scale well, so if application's demand
increases I see a minimal increase in database server load.

I was just looking for some pointers as to where to go to ITO hardware
for the future, as I can now spec a new  machine. I mean is it really
worth while going for one of those RAID controllers with the battery
backed cache, for instance. If so, are there any specific ones to look
out for? Which is better RAID 5, a large RAID 10 or smaller RAID 10's?
Should I bother with RAID at all?



pgsql-performance by date:

Previous
From: Tobias Brox
Date:
Subject: Re: SAN vs Internal Disks
Next
From: "Claus Guttesen"
Date:
Subject: Re: Hardware spec