pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: fred@redhotpenguin.com
To: scott.marlowe <scott.marlowe@ihs.com>
Cc: Rod Taylor <pg@rbt.ca>
Cc: cfield@affinitysolutions.com, "Postgresql Performance" <pgsql-performance@postgresql.org>
Subject: Re: Value of Quad vs. Dual Processor machine
Date: Tue, 11 Nov 2003 17:11:20 -0800 (PST)
Message-ID: <53970.127.0.0.1.1068599480.squirrel@127.0.0.1> (raw)
In-Reply-To: <Pine.LNX.4.33.0311111738060.29825-100000@css120.ihs.com>
References: <1068594688.28107.16.camel@jester>
	<Pine.LNX.4.33.0311111738060.29825-100000@css120.ihs.com>

> On Tue, 11 Nov 2003, Rod Taylor wrote:
>
>> On Tue, 2003-11-11 at 18:32, Chris Field wrote:
>> > We are getting ready to spec out a new machine and are wondering about
>> > the wisdom of buying a quad versus a dual processor machine.  Seing as
>> > how postgres in not a threaded application, and this server will only
>> be
>> > used for log/transaction analysis (it will only ever have a few large
>> > queries running).  Is there any performance to be gained, and if so is
>> > it worth the large cost?  Any thoughts/experience are much
>> > appreciated...
>>
>> Since you're asking the question, I'll assume you don't have CPU
>> intensive queries or monstrous loads.
>>
>> I'd probably invest in a Quad system with 2 chips in it (2 empty
>> sockets) and put the difference in funds into a few extra GB of Ram or
>> improved IO.
>>
>> In 6 months or a year, if you start doing longer or more complex
>> queries, toss in the other 2 chips. So long as you don't hit a memory
>> limit, it'll be fine.
>
> Note that you want to carefully look at the difference in cost of the
> motherboard versus the CPUs.  It's often the motherboard that raises the
> cost, not the CPUs so much.  Although with Xeons, the CPUs are not cheap.
>
> The second issue is that Intel (and AMD probably) only guarantee proper
> performance from chips int he same batch, so you may wind up replacing the
> two working CPUs with two new ones to go with the other two you'll be
> buying, to make sure that they work together.
>
> My guess is that more CPUs aren't gonna help this problem a lot, so look
> more at fast RAM and lots of it, as well as a fast I/O subsystem.
>
> 2 CPUs should be plenty.
I agree that the additional cpus won't help as much since I haven't found
any benefits in terms of individual query speed for a quad vs. an smp on
benchmarks I've run on test machines I was considering purchasing.  Quads
are also expensive - on similar architectures the quad was 20k vs 7k for
the dual.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>




view thread (12+ messages)  latest in thread

Message-ID: <53970.127.0.0.1.1068599480.squirrel@127.0.0.1>
Permalink:  ../53970.127.0.0.1.1068599480.squirrel@127.0.0.1/
Also on:    postgresql.org/message-id/53970.127.0.0.1.1068599480.squirrel@127.0.0.1

 · 

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: fred@redhotpenguin.com, scott.marlowe@ihs.com, pg@rbt.ca
  Subject: Re: Value of Quad vs. Dual Processor machine
  In-Reply-To: <53970.127.0.0.1.1068599480.squirrel@127.0.0.1>

* 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