Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id E88A72E028E for ; Wed, 19 Dec 2007 15:37:48 -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 33742-09 for ; Wed, 19 Dec 2007 15:37:46 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 90EA92E0041 for ; Wed, 19 Dec 2007 15:37:48 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id lBJJbeNi058578 for ; Wed, 19 Dec 2007 15:37:40 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id lBJJE0eX053162 for pgsql-performance@postgresql.org; Wed, 19 Dec 2007 15:14:00 -0400 (AST) (envelope-from news) From: Ron Mayer X-Newsgroups: pgsql.performance Subject: Re: Dual core Opterons beating quad core Xeons? Date: Wed, 19 Dec 2007 11:14:08 -0800 Organization: Hub.Org Networking Services Lines: 23 Message-ID: References: <476908BB.5090408@stuartbishop.net> <20071219105921.07b45a36@commandprompt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Icedove 1.5.0.14pre (X11/20071020) In-Reply-To: <20071219105921.07b45a36@commandprompt.com> To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/290 X-Sequence-Number: 28106 Joshua D. Drake 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... > > This has gotten better every release. 8.1 for example handles 8 cores > very well, 8.0 didn't and 7.4 well.... :) I agree with the spirit of what you say, but are you overstating things a bit? Benchmarks I see[1] suggest that 8.1.2 scaled pretty reasonably to 16 cores (from the chart on page 9 in the link below). But yeah, 8.0 scaled to maybe 2 cores if you're lucky. :-) Agree with the rest of the things you say, tho. It's getting way better every recent release. [1] http://www.pgcon.org/2007/schedule/attachments/22-Scaling%20PostgreSQL%20on%20SMP%20Architectures%20--%20An%20Update