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 5CE44D1B51C for ; Wed, 12 Nov 2003 14:28:48 +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 91126-09 for ; Wed, 12 Nov 2003 10:28:20 -0400 (AST) Received: from jefftrout.com (h00a0cc4084e5.ne.client2.attbi.com [24.128.241.68]) by svr1.postgresql.org (Postfix) with SMTP id 73FB4D1B50D for ; Wed, 12 Nov 2003 10:28:15 -0400 (AST) Received: (qmail 77237 invoked from network); 12 Nov 2003 14:28:21 -0000 Received: from localhost (HELO squeegit) (threshar@127.0.0.1) by localhost with SMTP; 12 Nov 2003 14:28:21 -0000 Date: Wed, 12 Nov 2003 09:28:07 -0500 From: Jeff To: "Chris Field" Cc: ron.l.johnson@cox.net, pgsql-performance@postgresql.org Subject: Re: Value of Quad vs. Dual Processor machine Message-Id: <20031112092807.14b18bf4.threshar@torgo.978.org> In-Reply-To: <001401c3a8c2$8c8fec30$040210ac@win2000> References: <1068593567.2063.8.camel@tuxsrva> <1068600291.30969.53.camel@haggis.homelan> <001401c3a8c2$8c8fec30$040210ac@win2000> X-Mailer: Sylpheed version 0.9.7 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/62 X-Sequence-Number: 4622 On Tue, 11 Nov 2003 21:13:19 -0500 "Chris Field" wrote: > we are looking at Xeon, We are currently running it on a quad sun v880 > compiled to be 64bit and have been getting dreadful performance. I > don't think we really have much to gain from going 64bit. > > By chance, are you running 7.3.4 on that sun? If so, try this: export CFLAGS=-02 ./configure and rebuild PG. Before 7.4 PG was build with _no_ optimization on Solaris. Recompiling gives __HUGE__ (notice the underscores) performance gains. And onto the dual vs quad. PG will only use 1 cpu / connection / query. So if your machine iwll have 1-2 queries running at a time those other 2 proc's will sit around idling. However if you are going to have a bunch going, 4 cpus will be most useful. One of hte nicest things to do for PG is more ram and fast IO. It really loves those things. good luck -- Jeff Trout http://www.jefftrout.com/ http://www.stuarthamm.net/