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 EA3E7D1B4FA for ; Tue, 11 Nov 2003 23:51:55 +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 56717-03 for ; Tue, 11 Nov 2003 19:51:27 -0400 (AST) Received: from mail.hive.nj2.inquent.com (mc.carriermail.com [205.178.180.9]) by svr1.postgresql.org (Postfix) with SMTP id 8ACD0D1B531 for ; Tue, 11 Nov 2003 19:51:23 -0400 (AST) Received: (qmail 4509 invoked from network); 11 Nov 2003 23:51:50 -0000 Received: from unknown (HELO ?192.168.1.199?) (134.22.68.129) by 205.178.180.9 with SMTP; 11 Nov 2003 23:51:50 -0000 Subject: Re: Value of Quad vs. Dual Processor machine From: Rod Taylor To: cfield@affinitysolutions.com Cc: Postgresql Performance In-Reply-To: <1068593567.2063.8.camel@tuxsrva> References: <1068593567.2063.8.camel@tuxsrva> Content-Type: text/plain Message-Id: <1068594688.28107.16.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 11 Nov 2003 18:51:28 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/52 X-Sequence-Number: 4612 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.