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
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