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 5DF94D1B50B for ; Wed, 12 Nov 2003 02:12:09 +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 75635-09 for ; Tue, 11 Nov 2003 22:11:41 -0400 (AST) Received: from corp1.affinitysolutions.com (corp1.affinitysolutions.com [216.52.88.186]) by svr1.postgresql.org (Postfix) with ESMTP id 76B2BD1B53B for ; Tue, 11 Nov 2003 22:11:37 -0400 (AST) Received: from win2000 (24-193-100-224.nyc.rr.com [24.193.100.224]) by corp1.affinitysolutions.com (Postfix) with ESMTP id BAAF111F703; Tue, 11 Nov 2003 21:11:39 -0500 (EST) Message-ID: <001401c3a8c2$8c8fec30$040210ac@win2000> Reply-To: "Chris Field" From: "Chris Field" To: "Ron Johnson" , "PgSQL Performance ML" References: <1068593567.2063.8.camel@tuxsrva> <1068600291.30969.53.camel@haggis.homelan> Subject: Re: Value of Quad vs. Dual Processor machine Date: Tue, 11 Nov 2003 21:13:19 -0500 Organization: Affinity Solutions MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=BAYES_30, QUOTED_EMAIL_TEXT, RCVD_IN_NJABL, REFERENCES, X_NJABL_OPEN_PROXY X-Spam-Level: X-Archive-Number: 200311/57 X-Sequence-Number: 4617 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. ----- Original Message ----- From: "Ron Johnson" To: "PgSQL Performance ML" Sent: Tuesday, November 11, 2003 8:24 PM Subject: Re: [PERFORM] Value of Quad vs. Dual Processor machine > On Tue, 2003-11-11 at 17: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... > > Xeon or Opteron? The faster Opterons *really* blaze, especially > in 64-bit mode. As others have said, though, RAM and I/O are most > important. > > -- > ----------------------------------------------------------------- > Ron Johnson, Jr. ron.l.johnson@cox.net > Jefferson, LA USA > > "As I like to joke, I may have invented it, but Microsoft made it > popular" > David Bradley, regarding Ctrl-Alt-Del > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > >