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

Re: Technical recommendations

From: William Yu <wyu(at)talisys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Technical recommendations
Date: 2004-08-30 11:48:31
Message-ID: cgv4j9$1shc$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-general
Francois Suter wrote:
> I have received via the Advocacy questions about optimising a database 
> server using PostgreSQL. The people asking the questions are planning to 
> buy a new machine, solely dedicated to serving PostgreSQL. Being no 
> specialist of optimisation, could someone help?
> 
> They are interested in the 64-bit compatibility and are wondering which 
> is better: a machine equiped with Opteron or AMD Athlon 64 3800?

For a server, ECC memory is mandatory. That narrows it down to Opteron 
or A64 FX 940 (which is the same thing as an Opteron 1XX). Getting 
non-ECC, non-registered memory (A64 3800) would mean (1) succeptible to 
crashing/data corruption from memory errors, (2) much lower max memory 
size, (3) lower performance when you fill up all memory banks.

> What other components should they bet strongly on: RAM, HD, network card?

High read activity -- a ton of RAM. High write activity -- a kickass 
SCSI RAID-0/1 config.

In response to

Responses

pgsql-general by date

Next:From: Raymond O'DonnellDate: 2004-08-30 12:00:48
Subject: European dates with Win32 version
Previous:From: Peter EisentrautDate: 2004-08-30 11:35:16
Subject: Re: Technical recommendations

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