Dear Iñigo Martinez Lasala，
Thank you for your replay and advice.
My company is a software application vendor, and our customer is useing
PostgreSQL 8.1.3.
When our application is runing , the DB sluggish suddenly and application stop.
To <javascript:;> prove that it is not the problem of the application ,We need
some evidence to certified this version have problem and show to our customer.
And Can I ask you <javascript:;> several questions?
1、 Can you recreate the "Context-switch storm" in the your old version
PostgreSQL 8.1.15 ?
2、 If you can ,could you please tell me your test case ？
Thank you so much！
Best regards,
Ray Huang
_____
发件人: Iñigo Martinez Lasala [mailto:imarti...@vectorsf.com]
发送时间: 2010年5月28日 15:43
收件人: 黄永卫
抄送: pgsql-admin
主题: Re: About "Context-switch storm" problem
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.hu...@gmail.com
<mailto:%3d%3futf-8%3fq%3f%3de9%3dbb%3d84%3de6%3db0%3db8%3de5%3d8d%3dab%3f%3d%20%3cyongwei.hu...@gmail.com%3e>
>
To: imarti...@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
