Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id BD89962D9D2 for ; Fri, 28 May 2010 04:43:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 98378-05 for ; Fri, 28 May 2010 07:43:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62]) by mail.postgresql.org (Postfix) with ESMTP id 259CF632266 for ; Fri, 28 May 2010 04:43:13 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by hermes.vectorsf.com (Postfix) with ESMTP id 2893E11C0149; Fri, 28 May 2010 09:43:10 +0200 (CEST) X-Virus-Scanned: amavisd-new at hermes.vectorsf.com Received: from hermes.vectorsf.com ([127.0.0.1]) by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id kcVf1eJEHrx4; Fri, 28 May 2010 09:43:04 +0200 (CEST) Received: from [10.70.4.200] (unknown [10.70.4.200]) (Authenticated sender: imartinez) by hermes.vectorsf.com (Postfix) with ESMTP id 0045611C008F; Fri, 28 May 2010 09:43:03 +0200 (CEST) Subject: Re: About "Context-switch storm" problem From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala To: =?UTF-8?Q?=E9=BB=84=E6=B0=B8=E5=8D=AB?= Cc: pgsql-admin In-Reply-To: <62F94C41871A4EF1BECEF463739B7A47@NECSLGZ0061411> References: <62F94C41871A4EF1BECEF463739B7A47@NECSLGZ0061411> Content-Type: multipart/alternative; boundary="=-5DIsr7vHa/4tSaWwSP95" Date: Fri, 28 May 2010 09:43:04 +0200 Message-ID: <1275032584.19383.71.camel@deimos> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.791 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/276 X-Sequence-Number: 34749 --=-5DIsr7vHa/4tSaWwSP95 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit Hi, Yongwei We finally upgraded our database server to last PostgreSQL 8.2 available. Since 8.2 does not include any major change (8.3 does indeed a lot of them) we had no problem with this upgrade. And believe, our database was really complex. About 600 tables with 300 stored procedures, wide use of embedded functions from different packages (including tsearch2) and lot of triggers and views. Not problems at all. Migrating to 8.3 or 8.4 is another history. So, my recommendation is to migrate to 8.2.17 -----Original Message----- From: 黄永卫 To: imartinez@vectorsf.com Subject: About "Context-switch storm" problem Date: Fri, 28 May 2010 13:31:54 +0800 Hello，Iñigo Martinez Lasala ! I read your mail about “Context-switch storm in 8.1.15” from postgres website. I think I meet the same problem as you now . Recently my company’s postgres DB server sluggish suddenly with a hight Context-switching value as below: 2010-04-07 04:03:15 procs memory swap io system cpu 2010-04-07 04:03:15 r b swpd free buff cache si so bi bo in cs us sy id wa 2010-04-07 14:04:27 3 0 0 2361272 272684 3096148 0 0 3 1445 973 14230 7 8 84 0 2010-04-07 14:05:27 2 0 0 2361092 272684 3096220 0 0 3 1804 1029 31852 8 10 81 1 2010-04-07 14:06:27 1 0 0 2362236 272684 3096564 0 0 3 1865 1135 19689 9 9 81 0 2010-04-07 14:07:27 1 0 0 2348400 272720 3101836 0 0 3 1582 1182 149461 15 17 67 0 2010-04-07 14:08:27 3 0 0 2392028 272840 3107600 0 0 3 3093 1275 203196 24 23 53 1 2010-04-07 14:09:27 3 1 0 2386224 272916 3107960 0 0 3 2486 1331 193299 26 22 52 0 2010-04-07 14:10:27 34 0 0 2332320 272980 3107944 0 0 3 1692 1082 214309 24 22 54 0 2010-04-07 14:11:27 1 0 0 2407432 273028 3108092 0 0 6 2770 1540 76643 29 13 57 1 2010-04-07 14:12:27 9 0 0 2358968 273104 3108388 0 0 7 2639 1466 10603 22 6 72 1 I May I know your solution after that ? Thank you ! Best wishes, Ray Huang --=-5DIsr7vHa/4tSaWwSP95 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 7bit Hi, Yongwei

We finally upgraded our database server to last PostgreSQL 8.2 available.

Since 8.2 does not include any major change (8.3 does indeed a lot of them) we had no problem with this upgrade. And believe, our database was really complex. About 600 tables with 300 stored procedures, wide use of embedded functions from different packages (including tsearch2) and lot of triggers and views. Not problems at all.

Migrating to 8.3 or 8.4 is another history. So, my recommendation is to migrate to 8.2.17

-----Original Message-----
From: 黄永卫 <yongwei.huang@gmail.com>
To: imartinez@vectorsf.com
Subject: About "Context-switch storm" problem
Date: Fri, 28 May 2010 13:31:54 +0800

Hello，Iñigo Martinez Lasala !

   

I read your mail about “Context-switch storm in 8.1.15” from postgres website.

I think I meet the same problem as you now .

Recently my company’s  postgres DB server sluggish suddenly with a hight Context-switching value as below:

 

2010-04-07 04:03:15 procs                      memory      swap          io     system         cpu

2010-04-07 04:03:15  r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs us sy id wa

2010-04-07 14:04:27  3  0      0 2361272 272684 3096148    0    0     3  1445  973 14230  7  8 84  0

2010-04-07 14:05:27  2  0      0 2361092 272684 3096220    0    0     3  1804 1029 31852  8 10 81  1

2010-04-07 14:06:27  1  0      0 2362236 272684 3096564    0    0     3  1865 1135 19689  9  9 81  0

2010-04-07 14:07:27  1  0      0 2348400 272720 3101836    0    0     3  1582 1182 149461 15 17 67  0

2010-04-07 14:08:27  3  0      0 2392028 272840 3107600    0    0     3  3093 1275 203196 24 23 53  1

2010-04-07 14:09:27  3  1      0 2386224 272916 3107960    0    0     3  2486 1331 193299 26 22 52  0

2010-04-07 14:10:27 34  0      0 2332320 272980 3107944    0    0     3  1692 1082 214309 24 22 54  0

2010-04-07 14:11:27  1  0      0 2407432 273028 3108092    0    0     6  2770 1540 76643 29 13 57  1

2010-04-07 14:12:27  9  0      0 2358968 273104 3108388    0    0     7  2639 1466 10603 22  6 72  1

 

 

I

May I know your solution after  that ?

 

 

 

Thank you !

Best wishes,

Ray Huang



--=-5DIsr7vHa/4tSaWwSP95--