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 8BECF32BA38 for ; Thu, 14 Oct 2004 20:59:11 +0100 (BST) 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 37592-10 for ; Thu, 14 Oct 2004 19:58:58 +0000 (GMT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id F0C3F32AE2C for ; Thu, 14 Oct 2004 20:58:58 +0100 (BST) Received: (qmail 17950 invoked from network); 14 Oct 2004 20:00:23 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.36?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 14 Oct 2004 20:00:23 -0000 Subject: Re: Excessive context switching on SMP Xeons From: Dave Cramer Reply-To: pg@fastcrypt.com To: Bill Montgomery Cc: Michael Adler , perform In-Reply-To: <41658F8D.9090204@lulu.com> References: <4162CA14.6080206@lulu.com> <200410050947.36174.josh@agliodbs.com> <41630D50.3020308@lulu.com> <200410051538.51664.josh@agliodbs.com> <41636D8E.1090403@rentec.com> <41648446.5020102@bigfoot.com> <4164B48C.9060202@rentec.com> <41656559.70100@lulu.com> <20041007181537.GA1693@pobox.com> <41658F8D.9090204@lulu.com> Content-Type: text/plain Organization: Cramer Consulting Message-Id: <1097783954.7978.501.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Thu, 14 Oct 2004 15:59:14 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/195 X-Sequence-Number: 8671 Bill, In order to manifest the context switch problem you will definitely require clients to be set to more than one in pgbench. It only occurs when 2 or more backends need access to shared memory. If you want help backpatching Gavin's patch I'll be glad to do it for you, but you do need a recent kernel. Dave On Thu, 2004-10-07 at 14:48, Bill Montgomery wrote: > Michael Adler wrote: > > >On Thu, Oct 07, 2004 at 11:48:41AM -0400, Bill Montgomery wrote: > > > > > >>Alan Stange wrote: > >> > >>The same test on a Dell PowerEdge 1750, Dual Xeon 3.2 GHz, 512k cache, > >>HT on, Linux 2.4.21-20.ELsmp (RHEL 3), 4GB memory, pg 7.4.5: > >> > >>Far less performance that the Dual Opterons with a low number of > >>clients, but the gap narrows as the number of clients goes up. Anyone > >>smarter than me care to explain? > >> > >> > > > >You'll have to wait for someone smarter than you, but I will posit > >this: Did you use a tmpfs filesystem like Alan? You didn't mention > >either way. Alan did that as an attempt remove IO as a variable. > > > >-Mike > > > > > > Yes, I should have been more explicit. My goal was to replicate his > experiment as closely as possible in my environment, so I did run my > postgres data directory on a tmpfs. > > -Bill Montgomery > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- Dave Cramer 519 939 0336 ICQ # 14675561 www.postgresintl.com