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 12C99D1CC8D for ; Mon, 19 Apr 2004 18:58:54 -0300 (ADT) 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 28070-08 for ; Mon, 19 Apr 2004 18:58:55 -0300 (ADT) Received: from mailout05.sul.t-online.com (mailout05.sul.t-online.com [194.25.134.82]) by svr1.postgresql.org (Postfix) with ESMTP id 60CC0D1CACF for ; Mon, 19 Apr 2004 18:58:52 -0300 (ADT) Received: from fwd04.aul.t-online.de by mailout05.sul.t-online.com with smtp id 1BFgAB-0006lt-01; Mon, 19 Apr 2004 23:18:47 +0200 Received: from aeccom.com (Ek4eAcZGQeKPbfWeYc-9iHLKRPA1WT-9F+6OpXlIg+UbP1he0hDTYg@[217.231.172.140]) by fwd04.sul.t-online.com with esmtp id 1BFg9s-13rlK40; Mon, 19 Apr 2004 23:18:28 +0200 Message-ID: <40844223.9070200@aeccom.com> Date: Mon, 19 Apr 2004 23:18:27 +0200 From: Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck) Reply-To: lutzeb@aeccom.com User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.1) Gecko/20031030 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Josh Berkus , pgsql-performance@postgreSQL.org, Neil Conway Subject: Re: Wierd context-switching issue on Xeon References: <200311251419.36771.josh@agliodbs.com> <407EFC95.5070805@aeccom.com> <11437.1082324861@sss.pgh.pa.us> <200404191050.12833.josh@agliodbs.com> <26941.1082397601@sss.pgh.pa.us> In-Reply-To: <26941.1082397601@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Seen: false X-ID: Ek4eAcZGQeKPbfWeYc-9iHLKRPA1WT-9F+6OpXlIg+UbP1he0hDTYg X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/304 X-Sequence-Number: 6604 I would agree to Tom, that too much parameters are involved to blame bigmem. I have access to the following machines where the same application operates: a) Dual (4way) XEON MP, bigmem, HT off, ServerWorks chipset (a Fujitsu-Siemens Primergy) performs ok now because missing indexes were added but this is no proof that this behaviour occurs again under high load, context switches are moderate but have peaks to 40.000 b) Dual XEON DP, non-bigmem, HT on, ServerWorks chipset (a Dell machine I think) performs moderate because I see too much context switches here although the mentioned indexes are created, context switches go up to 30.000 often, I can see 50% semop calls c) Dual XEON DP, non-bigmem, HT on, E7500 Intel chipset (Supermicro) performs well and I could not observe context switch peaks here (one user active), almost no extra semop calls d) Dual XEON DP, bigmem, HT off, ServerWorks chipset (a Fujitsu-Siemens Primergy) performance unknown at the moment (is offline) but looks like a) in the past I can offer to do tests on those machines if somebody would provide me some test instructions to nail this problem down. Dirk Tom Lane wrote: >Josh Berkus writes: > > >>The other thing I'd like your comment on, Tom, is that Dirk appears to have >>reported that when he installed a non-bigmem kernel, the issue went away. >>Dirk, is this correct? >> >> > >I'd be really surprised if that had anything to do with it. AFAIR >Dirk's test changed more than one variable and so didn't prove a >connection. > > regards, tom lane > > >