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 C58F4D1D2B7 for ; Wed, 21 Apr 2004 00:47:53 -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 55599-10 for ; Wed, 21 Apr 2004 00:47:52 -0300 (ADT) Received: from joeconway.com (66-146-172-82.skyriver.net [66.146.172.82]) by svr1.postgresql.org (Postfix) with ESMTP id 251B5D1D267 for ; Wed, 21 Apr 2004 00:47:51 -0300 (ADT) Received: from [192.168.4.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 1476184; Tue, 20 Apr 2004 20:42:02 -0700 Message-ID: <4085EEB2.5080007@joeconway.com> Date: Tue, 20 Apr 2004 20:46:58 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: josh@agliodbs.com, "scott.marlowe" , Bruce Momjian , lutzeb@aeccom.com, pgsql-performance@postgresql.org, Neil Conway Subject: Re: Wierd context-switching issue on Xeon References: <40843E63.7050101@joeconway.com> <200404191455.04068.josh@agliodbs.com> <1407.1082419316@sss.pgh.pa.us> <40849235.2070808@joeconway.com> In-Reply-To: <40849235.2070808@joeconway.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit 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/330 X-Sequence-Number: 6630 Joe Conway wrote: >> In isolation, test_run.sql should do essentially no syscalls at all once >> it's past the initial ramp-up. On a machine that's functioning per >> expectations, multiple copies of test_run show a relatively low rate of >> semop() calls --- a few per second, at most --- and maybe a delaying >> select() here and there. Here's results for 7.4 on a dual Athlon server running fedora core: CPU states: cpu user nice system irq softirq iowait idle total 86.0% 0.0% 52.4% 0.0% 0.0% 0.0% 61.2% cpu00 37.6% 0.0% 29.7% 0.0% 0.0% 0.0% 32.6% cpu01 48.5% 0.0% 22.7% 0.0% 0.0% 0.0% 28.7% procs memory swap io system cpu r b swpd free buff cache si so bi bo in cs 1 0 120448 25764 48300 1094576 0 0 0 124 170 187 1 0 120448 25780 48300 1094576 0 0 0 0 152 89 2 0 120448 25744 48300 1094580 0 0 0 60 141 78290 2 0 120448 25752 48300 1094580 0 0 0 0 131 140326 2 0 120448 25756 48300 1094576 0 0 0 40 122 140100 2 0 120448 25764 48300 1094584 0 0 0 60 133 136595 2 0 120448 24284 48300 1094584 0 0 0 200 138 135151 The jump in cs corresponds to starting the query in the second session. Joe