Skip site navigation (1) Skip section navigation (2)

Re: Server Hardware Configuration

From: Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Server Hardware Configuration
Date: 2005-11-21 09:34:36
Message-ID: 1132565676.8689.9.camel@ekim (view raw or flat)
Thread:
Lists: pgsql-admin
On Sun, 2005-11-20 at 11:53 -0600, Jim C. Nasby wrote:
> Two general comments: most people find that Opterons perform much better
> than Xeons. With some versions of PostgreSQL, the difference is over
> 50%.

Could you be more specific on that? Which version of Postgres perform
better on Opteron than on Xeon?

> RAID5 generally doesn't make for a fast database. The problem is that
> there is a huge amount of overhead everytime you go to write something
> out to a RAID5 array. With careful tuning of the background writer you
> might be able to avoid some of that penalty, though your read
> performance will likely still be affected by the write overhead.

RAID5 was not ment to improve performance, but to minimize disaster and
downtime when your hard disk dies. We're using RAID5 with postgres. In
the last 3 years we changed 5 disks, but the system downtime was zero
minutes.


	Mike
-- 
Mario Splivalo
Mob-Art
mario(dot)splivalo(at)mobart(dot)hr

"I can do it quick, I can do it cheap, I can do it well. Pick any two."



In response to

Responses

pgsql-admin by date

Next:From: Mario SplivaloDate: 2005-11-21 09:47:05
Subject: Re: installation of postgresql8.0.1 on Solaris 10
Previous:From: Gary HoffmanDate: 2005-11-21 06:05:52
Subject: Accumulating idle processes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group