X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C8DF0529B6 for ; Sun, 31 Jul 2005 18:12:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37050-03 for ; Sun, 31 Jul 2005 21:12:05 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6C8CF529AA for ; Sun, 31 Jul 2005 18:12:03 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id BB3BB3095A; Sun, 31 Jul 2005 23:20:15 +0200 (MET DST) From: William Yu X-Newsgroups: pgsql.performance Subject: Re: Performance problems on 4/8way Opteron (dualcore) Date: Sun, 31 Jul 2005 14:11:58 -0700 Organization: Hub.Org Networking Services Lines: 30 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en In-Reply-To: To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.017 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/506 X-Sequence-Number: 13747 A 4xDC would be far more sensitive to poor NUMA code than 2xDC so I'm not surprised I don't see performance issues on our 2xDC w/ < 2.6.12. J. Andrew Rogers wrote: > On 7/30/05 12:57 AM, "William Yu" wrote: > >>I haven't investigated the 2.6.12+ kernel updates yet -- I probably will >>do our development servers first to give it a test. > > > > The kernel updates make the NUMA code dual-core aware, which apparently > makes a big difference in some cases but not in others. It makes some > sense, since multi-processor multi-core machines will have two different > types of non-locality instead of just one that need to be managed. Prior to > the v2.6.12 patches, a dual-core dual-proc machine was viewed as a quad-proc > machine. > > The closest thing to a supported v2.6.12 kernel that I know of is FC4, which > is not really supported in the enterprise sense of course. > > > J. Andrew Rogers > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >