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 F20B8D1DD59 for ; Tue, 20 Apr 2004 10:04:27 -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 08341-08 for ; Tue, 20 Apr 2004 10:04:28 -0300 (ADT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id AE033D1DD42 for ; Tue, 20 Apr 2004 10:04:24 -0300 (ADT) Received: (qmail 21581 invoked from network); 20 Apr 2004 13:04:20 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.36?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 20 Apr 2004 13:04:20 -0000 Subject: Re: Wierd context-switching issue on Xeon From: Dave Cramer Reply-To: pg@fastcrypt.com To: Jeff Cc: Tom Lane , Bruce Momjian , Joe Conway , Neil Conway , Josh Berkus , lutzeb@aeccom.com, pgsql-performance@postgresql.org, "scott.marlowe" In-Reply-To: References: <40843E63.7050101@joeconway.com> <200404191455.04068.josh@agliodbs.com> <1407.1082419316@sss.pgh.pa.us> Content-Type: text/plain Organization: Cramer Consulting Message-Id: <1082466419.3069.132.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Tue, 20 Apr 2004 09:06:59 -0400 Content-Transfer-Encoding: 7bit X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/294 X-Sequence-Number: 6594 Dual Athlon With one process running 30 cs/second with two process running 15000 cs/second Dave On Tue, 2004-04-20 at 08:46, Jeff wrote: > On Apr 19, 2004, at 8:01 PM, Tom Lane wrote: > [test case] > > Quad P3-700Mhz, ServerWorks, pg 7.4.2 - 1 process: 10-30 cs / second > 2 process: 100k cs / sec > 3 process: 140k cs / sec > 8 process: 115k cs / sec > > Dual P2-450Mhz, non-serverworks (piix) - 1 process 15-20 / sec > 2 process 30k / sec > 3 (up to 7) process: 15k /sec > > (Yes, I verified with more processes the cs's drop) > > And finally, > > 6 cpu sun e4500, solaris 2.6, pg 7.4.2: 1 - 10 processes: hovered > between 2-3k cs/second (there was other stuff running on the machine as > well) > > > Verrry interesting. > I've got a dual G4 at home, but for convenience Apple doesn't ship a > vmstat that tells context switches > > -- > Jeff Trout > http://www.jefftrout.com/ > http://www.stuarthamm.net/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > > > > !DSPAM:40851da1199651145780980! > > -- Dave Cramer 519 939 0336 ICQ # 14675561