pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dan Harris <fbsd@drivefaster.net>
To: pgsql-performance@postgresql.org
Subject: Hardware opinions wanted
Date: Thu, 27 May 2004 16:40:49 -0600
Message-ID: <40B66E71.7060703@drivefaster.net> (raw)

I wanted to solicit some opinions on architecture and performance from 
you guys.

I am torn right now between these two systems to replace my aging DB server:

4 x 2.2 GHz Opteron
8GB RAM
Ultra320 15kRPM RAID5 with 128MB cache

and

2-way 1.2GHz POWER4+ IBM pSeries 615
8GB RAM
Ultra320 15kRPM RAID5 with 64MB cache

I plan on serving ~80GB of pgsql database on this machine.  The current 
machine handles around 1.5 million queries per day.

I am having some trouble finding direct comparisons between the two 
architectures.  The OS will most likely be Linux ( I'm hedging on AIX 
for now ).  The pSeries has 8MB cache per CPU card ( 2 CPU on a card ) 
while the Opteron has 1MB for each processor.  I know the POWER4+ is a 
very fast machine but I wonder if having more processors in the Opteron 
system would beat it for database serving? FWIW, they are very close in 
price.

Ignoring the fault-tolerance features of the pSeries, which one would 
you pick for performance?

Thanks,
Dan



view thread (3+ messages)  latest in thread

Message-ID: <40B66E71.7060703@drivefaster.net>
Permalink:  ../40B66E71.7060703@drivefaster.net/
Also on:    postgresql.org/message-id/40B66E71.7060703@drivefaster.net

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: fbsd@drivefaster.net
  Subject: Re: Hardware opinions wanted
  In-Reply-To: <40B66E71.7060703@drivefaster.net>

* 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