pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Erwin Brandstetter <a9006241@unet.univie.ac.at>
To: pgsql-admin@postgresql.org
Subject: Re: Hardware for a database server
Date: Tue, 16 Mar 2004 08:43:34 GMT
Message-ID: <Xns94AE62FE64F35Xaraweda@195.34.132.18> (raw)
References: <Pine.LNX.4.33.0403100954270.10418-100000@css120.ihs.com>
	<404F5F2C.4070505@cranel.com>

Yo Scott, Greg & William!

I tried to send the following message last week, but my posting never 
got here. Guess my provider has fucked up. So here goes again, sorry 
for late reply.

For knowledgeable feedback I have asked, and that's what I have got.
Thanx a lot. My thanks also Jim Wilson who added some very good points 
in c.d.p.general.

Taken all into account, it has made me change my plans concerning CPU &
RAM: Dual-CPU (not single) with  2 GB of RAM (not 4) seems to be the 
better solution to start with.

I will go for the slowest Opterons (2 x Opteron 240), which will serve 
both performance & cost efficiency. They'll get 4 x 512 MB DDR SDRAM, 
PC333 most likely, which should suffice for quite some time. That takes 
the 2GB limit for 32bit OS into account and leaves room for upgrade to 
4 GB later when i switch to AMD64 Linux (if more RAM should be needed 
at all)..

Only the storage gives me a hard time. I got a lot of input from you 
all. Finally I decided to go for a simple SATA RAID 1 for the time 
being. Two of the new Western Digital Western Digital Raptor HDDs (10k 
SATA) might suffice after all.
If that should turn out to be a bottleneck, i will add an SCSI RAID 5 
system, while the OS stays on one of the SATA drives. The mainboard 
TYAN Thunder K8S Pro provides a PCI X slot ready for a SCSI controller 
card.

My sympathy for postgresql has prooved right once more. You gave me 
very profound advice. Thanx a lot!


Best Regards
Erwin Brandstetter



view thread (5+ messages)

Message-ID: <Xns94AE62FE64F35Xaraweda@195.34.132.18>
Permalink:  ../Xns94AE62FE64F35Xaraweda@195.34.132.18/
Also on:    postgresql.org/message-id/Xns94AE62FE64F35Xaraweda@195.34.132.18

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: a9006241@unet.univie.ac.at
  Subject: Re: Hardware for a database server
  In-Reply-To: <Xns94AE62FE64F35Xaraweda@195.34.132.18>
  References: <Pine.LNX.4.33.0403100954270.10418-100000@css120.ihs.com> <404F5F2C.4070505@cranel.com> <Xns94AE62FE64F35Xaraweda@195.34.132.18>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox