Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2D25D2E388A for ; Wed, 19 Dec 2007 15:14:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 21782-06 for ; Wed, 19 Dec 2007 15:14:37 -0400 (AST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.236]) by postgresql.org (Postfix) with ESMTP id 31E942E33A3 for ; Wed, 19 Dec 2007 15:14:39 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id l8so1495386nzf.28 for ; Wed, 19 Dec 2007 11:14:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=ZOT57kzJELN9zaiGX255KrB8iKGPP3SRmIm/Bs7ghM4=; b=kY1HSfB959ehimFzWssIzgBtcSi21aoZ8Fl5F0FQXdyD8n2j7mEfvj5uX6/N5kBoNs/JLh6VqqKxJpS1iwQQrC2fWhGDrvzojXLde6guZmCE6Qa1dSWaKZEGgEY2CUYe4HqX+fFwhCk+KZmPahZt1lBc+XxRl9b2gMPCLtGbQgU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=dWiaQccWPz7GnxdeatoC/UPXl7mrH2xAlMGtbb5bRTwa1I4fLU7KcDGQFwYezqiXnVyZaWtVuOWDuIxtvp0rSdRtpJeayA6RuHgiSW1Azy/Sm5VCXPw+EANrRNgvbGd6Ogaf63/qjjw4Aneq0Klm+j+C3G5LhkLLRJE+XlmM8fo= Received: by 10.142.12.14 with SMTP id 14mr1991005wfl.152.1198091677951; Wed, 19 Dec 2007 11:14:37 -0800 (PST) Received: by 10.142.143.6 with HTTP; Wed, 19 Dec 2007 11:14:37 -0800 (PST) Message-ID: Date: Wed, 19 Dec 2007 13:14:37 -0600 From: "Scott Marlowe" To: "Joshua D. Drake" Subject: Re: Dual core Opterons beating quad core Xeons? Cc: "Greg Smith" , "Stuart Bishop" , pgsql-performance@postgresql.org In-Reply-To: <20071219110744.32f9192a@commandprompt.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <476908BB.5090408@stuartbishop.net> <20071219105921.07b45a36@commandprompt.com> <20071219110744.32f9192a@commandprompt.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/289 X-Sequence-Number: 28105 On Dec 19, 2007 1:07 PM, Joshua D. Drake wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Wed, 19 Dec 2007 13:03:32 -0600 > "Scott Marlowe" wrote: > > > > > Actually this is not true. Although I have yet to test 8.3. It is > > > pretty much common knowledge that after 8 cores the acceleration of > > > performance drops with PostgreSQL... > > > > I thought Tom had played with some simple hacks that got the scaling > > pretty close to linear for up to 16 cores earlier this year... > > > > See.. have not tested 8.3 above and 8.2 is better than 8.1 etc... Well, I'm not even sure if those got applied or were just Tom hacking in the basement or, heck, my fevered imagination. :)