From: Hilary Forbes <hforbes@dmr.co.uk>
To: pgsql-performance@postgresql.org
Subject: Processors vs Memory
Date: Wed, 22 Oct 2003 11:09:55 +0100
Message-ID: <5.1.0.14.0.20031022110951.085d0d70@mailserver.ipl.co.uk> (raw)
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.
How long is a piece of string I guess but all comments welcome!
TAI
Hilary
Hilary Forbes
-------------
DMR Computer Limited: http://www.dmr.co.uk/
Direct line: 01689 889950
Switchboard: (44) 1689 860000 Fax: (44) 1689 860330
E-mail: hforbes@dmr.co.uk
**********************************************************
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: hforbes@dmr.co.uk
Subject: Re: Processors vs Memory
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>
* 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