X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 238449DCBB0 for ; Thu, 16 Mar 2006 10:30:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20605-04 for ; Thu, 16 Mar 2006 10:30:09 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.202]) by postgresql.org (Postfix) with ESMTP id 548399DCC0D for ; Thu, 16 Mar 2006 10:30:03 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 8so344950nzo for ; Thu, 16 Mar 2006 06:30:07 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=tCsrujKc5qenmLtrll9+6OBWzcf3DqTqKQPDDpmXXuTldE0Xa5P7eaf+6R3PeQVxMsIZA7eknie39Uq2BpjMYCzTy1/n0B0qicvsPJe2Oigxb81k2sSc8OJQ1E8S43h9HZGZ9pGKRb7+qd4lO6iuv2hqElReF1ZSBkLbh04ta4E= Received: by 10.65.225.14 with SMTP id c14mr751085qbr; Thu, 16 Mar 2006 06:30:07 -0800 (PST) Received: by 10.65.123.12 with HTTP; Thu, 16 Mar 2006 06:30:07 -0800 (PST) Message-ID: <1d4e0c10603160630g7fe945ffo1d723843407ed128@mail.gmail.com> Date: Thu, 16 Mar 2006 15:30:07 +0100 From: "Guillaume Smet" To: "Sven Geisler" Subject: Re: PostgreSQL and Xeon MP Cc: "Richard Huxton" , pgsql-performance@postgresql.org In-Reply-To: <441963F4.1010607@aeccom.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1d4e0c10603160245n55128e86t35431a339afcf8cc@mail.gmail.com> <44194A4B.3020106@archonet.com> <1d4e0c10603160428s1a3c1f4cocbe8489634524387@mail.gmail.com> <441963F4.1010607@aeccom.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.198 required=5 tests=[AWL=0.198] X-Spam-Score: 0.198 X-Spam-Level: X-Archive-Number: 200603/238 X-Sequence-Number: 17675 On 3/16/06, Sven Geisler wrote: > Hi Guillaume, > > I had a similar issue last summer. Could you please provide details > about your XEON MP server and some statistics (context-switches/load/CPU > usage)? I forgot the statistics: CPU load usually from 1 to 4. CPU usage < 40% for each processor usually and sometimes when the server completely hangs, it grows to 60%.., Here is a top output of the server at this time: 15:21:17 up 138 days, 13:25, 1 user, load average: 1.29, 1.25, 1.38 82 processes: 81 sleeping, 1 running, 0 zombie, 0 stopped CPU states: cpu user nice system irq softirq iowait idle total 25.7% 0.0% 3.9% 0.0% 0.3% 0.1% 69.7% cpu00 29.3% 0.0% 4.7% 0.1% 0.5% 0.0% 65.0% cpu01 20.7% 0.0% 1.9% 0.0% 0.3% 0.0% 76.8% cpu02 25.5% 0.0% 5.5% 0.0% 0.1% 0.3% 68.2% cpu03 27.3% 0.0% 3.3% 0.0% 0.1% 0.1% 68.8% Mem: 3857224k av, 3298580k used, 558644k free, 0k shrd, 105172k bu= ff 2160124k actv, 701304k in_d, 56400k in_c Swap: 4281272k av, 6488k used, 4274784k free 2839348k ca= ched We have currently between 3000 and 13000 context switches/s, average of 5000 I'd say visually. Here is a top output I had on november 17 when the server completely hangs (several minutes for each page of the website) and it is typical of this server behaviour: 17:08:41 up 19 days, 15:16, 1 user, load average: 4.03, 4.26, 4.36 288 processes: 285 sleeping, 3 running, 0 zombie, 0 stopped CPU states: cpu user nice system irq softirq iowait idle total 59.0% 0.0% 8.8% 0.2% 0.0% 0.0% 31.9% cpu00 52.3% 0.0% 13.3% 0.9% 0.0% 0.0% 33.3% cpu01 65.7% 0.0% 7.6% 0.0% 0.0% 0.0% 26.6% cpu02 58.0% 0.0% 7.6% 0.0% 0.0% 0.0% 34.2% cpu03 60.0% 0.0% 6.6% 0.0% 0.0% 0.0% 33.3% Mem: 3857224k av, 3495880k used, 361344k free, 0k shrd, 92160k bu= ff 2374048k actv, 463576k in_d, 37708k in_c Swap: 4281272k av, 25412k used, 4255860k free 2173392k ca= ched As you can see, load is blocked to 4, no iowait and cpu idle of 30%. Vmstat showed 5000 context switches/s on average so we had no context switch storm.