X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B3DD09FB2C8 for ; Mon, 7 Aug 2006 04:59:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 41004-09 for ; Mon, 7 Aug 2006 04:59:47 -0300 (ADT) X-Greylist: delayed 00:25:02.527122 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id DA24E9FB2D7 for ; Mon, 7 Aug 2006 04:59:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.revver.com (mail.revver.com [207.7.147.37]) by svr4.postgresql.org (Postfix) with ESMTP id 08BEF5AF04C for ; Mon, 7 Aug 2006 07:34:43 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.revver.com (Postfix) with ESMTP id 76F09B5C0A1 for ; Mon, 7 Aug 2006 00:34:42 -0700 (PDT) Received: from mail.revver.com ([127.0.0.1]) by localhost (neil.revver.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17369-06 for ; Mon, 7 Aug 2006 00:34:42 -0700 (PDT) Received: from [192.168.1.11] (c-66-229-34-91.hsd1.ca.comcast.net [66.229.34.91]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.revver.com (Postfix) with ESMTP id 1E7F7B5C083 for ; Mon, 7 Aug 2006 00:34:42 -0700 (PDT) Message-ID: <44D6EDFA.4030802@revver.com> Date: Mon, 07 Aug 2006 00:38:34 -0700 From: "Donald C. Sumbry ][" User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: High Context-Switches on Linux 8.1.4 Server Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at revver.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/63 X-Sequence-Number: 20248 Postgres 8.1.4 Slony 1.1.5 Linux manny 2.6.12-10-k7-smp #1 SMP Fri Apr 28 14:17:26 UTC 2006 i686 GNU/Linux We're seeing an average of 30,000 context-switches a sec. This problem was much worse w/8.0 and got bearable with 8.1 but slowly resurfaced. Any ideas? procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu---- r b swpd free buff cache si so bi bo in cs us sy id wa 8 2 0 392184 40248 3040628 0 0 10012 2300 3371 43436 60 25 11 4 10 2 0 334772 40256 3043340 0 0 2672 1892 3252 10073 84 14 1 1 9 2 0 338492 40280 3051272 0 0 7960 1612 3548 22013 77 16 4 3 11 2 0 317040 40304 3064576 0 0 13172 1616 3870 42729 61 21 11 7 7 0 0 291496 40320 3078704 0 0 14192 504 3139 52200 58 24 12 7 The machine has 4 gigs of RAM, shared_buffers = 32768, max_connections = 400, and currently does around 300-500 queries a second. I can provide more info if needed. -- Sumbry][