pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
To: Hilary Forbes <hforbes@dmr.co.uk>
Cc: pgsql-performance@postgresql.org
Subject: Re: Processors vs Memory
Date: Wed, 22 Oct 2003 15:55:22 +0530
Message-ID: <3F965B12.5010901@myrealbox.com> (raw)
In-Reply-To: <5.1.0.14.0.20031022110951.085d0d70@mailserver.ipl.co.uk>
References: <5.1.0.14.0.20031022110951.085d0d70@mailserver.ipl.co.uk>

Hilary Forbes wrote:

> If I have a fixed amount of money to spend as a general rule 
 >is it better to buy one processor and lots of memory or two
 >processors and less memory for a system which is transactional
 >based (in this case it's handling reservations).  I realise the
 >answer will be a generalised one but all the performance bits
 >I've read seem to talk about adjusting memory allocation.
 >The client has received the general advice from their hardware
 >supplier that 2 Xeon processors and less memory is better but
 >for postgresql I'm thinking they might be better off with a single
 >processor and loads of memory.  The OS is Red Hat Linux.

Well it depends. If your projected database size is say 2 gigs, then you should 
buy 2Gigsof RAM and spend rest of the money on processor.

But if your database size(max of currrent and projected) is 100GB, obviously you 
can not buy 100GB of memory that cheaply. So you should look for fast storage.

The order of priority is IO, memory and CPU. If database is just big enough to 
fit in a gig or two, you should get RAM first.

Processor is hardly ever a concern w.r.t database unless you are doing a lot in 
database business logic.

HTH

  Shridhar




view thread (3+ messages)  latest in thread

Message-ID: <3F965B12.5010901@myrealbox.com>
Permalink:  ../3F965B12.5010901@myrealbox.com/
Also on:    postgresql.org/message-id/3F965B12.5010901@myrealbox.com

 · 

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: shridhar_daithankar@myrealbox.com, hforbes@dmr.co.uk
  Subject: Re: Processors vs Memory
  In-Reply-To: <3F965B12.5010901@myrealbox.com>

* 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