pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim C. Nasby <jim@nasby.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Qing Zhao <qzhao@quotefx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: possible improvement between G4 and G5
Date: Tue, 6 Apr 2004 10:52:35 -0500
Message-ID: <20040406155235.GZ74840@nasby.net> (raw)
In-Reply-To: <19781.1081230442@sss.pgh.pa.us>
References: <009901c41b48$8357c860$2500fa0a@CardServices.TCI.com>
	<DDB7CC31-8764-11D8-9AA6-000A95AB8896@quotefx.net>
	<19781.1081230442@sss.pgh.pa.us>

On Tue, Apr 06, 2004 at 01:47:22AM -0400, Tom Lane wrote:
> Qing Zhao <qzhao@quotefx.net> writes:
> > We have got a G5 64-bit processor to replace an old G4 32-bit
> > processor.  Given everything else equal, should we see a big
> > improvement on PG's performance?
> 
> Nope.  Database performance typically depends on disk performance first,
> and RAM size second.  A 64-bit processor might help by allowing you to
> install more RAM, but you didn't say that you had.

Memory bandwidth is a consideration too, so you might see some
performance improvements on a G5. We recently debated between Xeons and
Opterons in a new PGSQL server and a little poking around on the lists
indicated that the Opterons did perform better, presumably due to the
increased memory bandwidth. Incidentally, this is why you need about 2x
the CPUs on Sun hardware vs RS6000 hardware for database stuff (and that
gets expensive if you're paying per CPU!).
-- 
Jim C. Nasby, Database Consultant                  jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"



view thread (9+ messages)  latest in thread

Message-ID: <20040406155235.GZ74840@nasby.net>
Permalink:  ../20040406155235.GZ74840@nasby.net/
Also on:    postgresql.org/message-id/20040406155235.GZ74840@nasby.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: jim@nasby.net, tgl@sss.pgh.pa.us, qzhao@quotefx.net
  Subject: Re: possible improvement between G4 and G5
  In-Reply-To: <20040406155235.GZ74840@nasby.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