X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9B9CED1B4F6 for ; Wed, 12 Nov 2003 01:11:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 65807-10 for ; Tue, 11 Nov 2003 21:11:23 -0400 (AST) Received: from redhotpenguin.com (12-240-9-202.client.attbi.com [12.240.9.202]) by svr1.postgresql.org (Postfix) with ESMTP id 31835D1B521 for ; Tue, 11 Nov 2003 21:11:19 -0400 (AST) Received: (qmail 29762 invoked from network); 12 Nov 2003 01:11:20 -0000 Received: from localhost (HELO 127.0.0.1) (127.0.0.1) by localhost with SMTP; 12 Nov 2003 01:11:20 -0000 Received: from 127.0.0.1 (proxying for 12.240.9.202) (SquirrelMail authenticated user fred@redhotpenguin.com) by 127.0.0.1 with HTTP; Tue, 11 Nov 2003 17:11:20 -0800 (PST) Message-ID: <53970.127.0.0.1.1068599480.squirrel@127.0.0.1> In-Reply-To: References: <1068594688.28107.16.camel@jester> Date: Tue, 11 Nov 2003 17:11:20 -0800 (PST) Subject: Re: Value of Quad vs. Dual Processor machine From: fred@redhotpenguin.com To: "scott.marlowe" Cc: "Rod Taylor" , cfield@affinitysolutions.com, "Postgresql Performance" User-Agent: SquirrelMail/1.4.2-1.qvcs.1 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/55 X-Sequence-Number: 4615 > 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) >