From: Raoul Buzziol <raoulus@libero.it>
To: pgsql-performance@postgresql.org
Subject: Re: Help specifying new machine
Date: Fri, 13 Aug 2004 08:29:15 +0200
Message-ID: <cfhmvr$1k4o$1@news.hub.org> (raw)
References: <20040809165657.GB15169@campbell-lange.net>
<cfgq0v$29k8$1@news.hub.org>
William Yu wrote:
> Rory Campbell-Lange wrote:
>
>> The present server is a 2GHz Pentium 4/512 KB cache with 2
>> software-raided ide disks (Maxtors) and 1GB of RAM.
>>
>>
>> I have been offered the following 1U server which I can just about
>> afford:
>>
>> 1U server
>> Intel Xeon 2.8GHz 512K cache 1
>> 512MB PC2100 DDR ECC Registered 2
>> 80Gb SATA HDD 4
>> 4 port SATA card, 3 ware 8506-4 1
>> 3 year next-day hardware warranty 1
>
> You're not getting much of a bump with this server. The CPU is
> incrementally faster -- in the absolutely best case scenario where your
> queries are 100% cpu-bound, that's about ~25%-30% faster.
What about using Dual Athlon MP instead of a Xeon? Would be much less expensive,
but have higher performance (I think).
>
> If you could use that money instead to upgrade your current server,
> you'd get a much bigger impact. Go for more memory and scsi (raid
> controllers w/ battery-backed cache).
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: raoulus@libero.it
Subject: Re: Help specifying new machine
In-Reply-To: <cfhmvr$1k4o$1@news.hub.org>
* 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