pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: William Yu <wyu@talisys.com>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL data on a NAS device ?
Date: Tue, 21 Oct 2003 09:12:14 -0700
Message-ID: <bn3lt1$107r$1@news.hub.org> (raw)
In-Reply-To: <009201c397d7$f4eb25c0$b696a8c0@APR>
References: <Pine.LNX.4.33.0310201118260.8351-100000@css120.ihs.com>
	<006201c397d1$932488f0$b696a8c0@APR>
	<3F952D41.9030603@myrealbox.com>
	<009201c397d7$f4eb25c0$b696a8c0@APR>

> I have never worked with a XEON CPU before. Does anyone know how it performs
> running PostgreSQL 7.3.4 / 7.4 on RedHat 9 ? Is it faster than a Pentium 4?
> I believe the main difference is cache memory, right? Aside from cache mem,
> it's basically a Pentium 4, or am I wrong?

Well, see the problem is of course, there's so many flavors of P4s and 
Xeons that it's hard to tell which is faster unless you specify the 
exact model. And even then, it would depend on the workload. Would a 
Xeon/3GHz/2MB L3/400FSB be faster than a P4C/3GHz/800FSB? No idea as no 
one has complete number breakdowns on these comparisons. Oh yeah, you 
could get a big round number that says on SPEC or something one CPU is 
faster than the other but whether that's faster for Postgres and your PG 
app is a totally different story.

That in mind, I wouldn't worry about it. The CPU is probably plenty fast 
for what you need to do. I'd look into two things in the server: memory 
and CPU expandability. I know you already plan on 4GB but you may need 
even more in the future. Few things can dramatically improve performance 
more than moving disk access to disk cache. And if there's a 2nd socket 
where you can pop another CPU in, that would leave you extra room if 
your server becomes CPU limited.




view thread (17+ messages)  latest in thread

Message-ID: <bn3lt1$107r$1@news.hub.org>
Permalink:  ../bn3lt1$107r$1@news.hub.org/
Also on:    postgresql.org/message-id/bn3lt1$107r$1@news.hub.org

 · 

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: wyu@talisys.com
  Subject: Re: PostgreSQL data on a NAS device ?
  In-Reply-To: <bn3lt1$107r$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