This is a multi-part message in MIME format.
------=_NextPart_000_0050_01CB00AE.2C5C5830
Content-Type: text/plain;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Dear I=C3=B1igo Martinez Lasala=EF=BC=8C
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=E3=80=81 Can you recreate the "Context-switch storm" in the your =
old version PostgreSQL 8.1.15 ?
2=E3=80=81 If you can ,could you please tell me your test case =
=EF=BC=9F
Thank you so much=EF=BC=81
Best regards,
Ray Huang
_____
=E5=8F=91ä=BB=B6ä=BA=BA: I=C3=B1igo Martinez Lasala =
[mailto:imartinez [at] vectorsf.com]
=E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2010=E5=B9=B45=E6=9C=8828=E6=97=A5 =
15:43
=E6=94=B6ä=BB=B6ä=BA=BA: =E9=BB=84=E6=B0=B8=E5=8D=AB
=E6=8A=84=E9=80=81: pgsql-admin
ä=B8=BB=E9=A2=98: 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: =E9=BB=84=E6=B0=B8=E5=8D=AB <yongwei.huang [at] gmail.com =
<mailto:%3d%3fUTF-8%3fQ%3f%3dE9%3dBB%3d84%3dE6%3dB0%3dB8%3dE5%3d8D%3dAB%3=
f%3d%20%3cyongwei.huang [at] gmail.com%3e> >
To: imartinez [at] vectorsf.com
Subject: About "Context-switch storm" problem
Date: Fri, 28 May 2010 13:31:54 +0800
Hello=EF=BC=8CI=C3=B1igo Martinez Lasala !
I read your mail about =E2=80=9CContext-switch storm in 8.1.15=E2=80=9D =
from postgres website.
I think I meet the same problem as you now .
Recently my company=E2=80=99s 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
------=_NextPart_000_0050_01CB00AE.2C5C5830
Content-Type: text/html;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
..shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"chsdate"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"chmetcnv"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:=E5=AE=8Bä=BD=93;
panose-1:2 1 6 0 3 1 1 1 1 1;}
[at] font-face
{font-family:"\ [at] =E5=AE=8Bä=BD=93";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:=E5=AE=8Bä=BD=93;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:=E5=AE=8Bä=BD=93;
color:navy;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
[at] page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
[at] list l0
{mso-list-id:1530489792;
mso-list-type:hybrid;
mso-list-template-ids:2100223954 90441842 67698713 67698715 67698703 =
67698713 67698715 67698703 67698713 67698715;}
[at] list l0:level1
{mso-level-text:%1=E3=80=81;
mso-level-tab-stop:18.0pt;
mso-level-number-position:left;
margin-left:18.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
</head>
<body lang=3DZH-CN link=3Dblue vlink=3Dblue>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D3 color=3Dblack =
face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US
style=3D'font-size:12.0pt;color:black'>Dear I=C3=B1igo Martinez =
Lasala</span>=EF=BC=8C<span
lang=3DEN-US><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dblack =
face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US
style=3D'font-size:12.0pt;color:black'>=C2=A0=C2=A0=C2=A0 Thank you for =
your replay and advice. <o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'margin-left:18.0pt;text-indent:6.0pt'><font size=3D3
color=3Dblack face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US =
style=3D'font-size:12.0pt;color:black'>My
company is a software application vendor<span class=3Dtrans>, and our =
customer =C2=A0is
useing </span>PostgreSQL <st1:chsdate IsROCDate=3D"False" =
IsLunarDate=3D"False"
Day=3D"30" Month=3D"12" Year=3D"1899" =
w:st=3D"on">8.1.3</st1:chsdate>.<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'text-indent:24.0pt'><font size=3D3 =
color=3Dblack face=3D=E5=AE=8Bä=BD=93><span
lang=3DEN-US style=3D'font-size:12.0pt;color:black'>When our application =
is runing
, the DB sluggish suddenly and application =
stop.<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'text-indent:24.0pt'><font size=3D3 =
color=3Dblack face=3D=E5=AE=8Bä=BD=93><span
lang=3DEN-US style=3D'font-size:12.0pt;color:black'>To <a =
href=3D"javascript:;"><font
color=3Dblack><span =
style=3D'color:black;text-decoration:none'>prove</span></font></a> t=
hat
it is not the problem of the application ,We need some evidence to =
certified
this version have problem and show to our =
customer.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dblack =
face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US
style=3D'font-size:12.0pt;color:black'>=C2=A0=C2=A0=C2=A0 And Can =
=C2=A0I ask you =C2=A0<a
href=3D"javascript:;"><font color=3Dblack><span =
style=3D'color:black;text-decoration:
none'>several</span></font></a> =
questions?<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dblack =
face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US
style=3D'font-size:12.0pt;color:black'><o:p> </o:p></span></font></p=
>
<p class=3DMsoNormal =
style=3D'margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0 level1 =
lfo1'><![if !supportLists]><font
size=3D2 color=3Dblack face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US =
style=3D'font-size:10.0pt;color:black'><span
style=3D'mso-list:Ignore'>1=E3=80=81<font size=3D1 face=3D"Times New =
Roman"><span
style=3D'font:7.0pt "Times New Roman"'> =
</span></font></span></span></font><![endif]><font
color=3Dblack><span lang=3DEN-US style=3D'color:black'>Can you recreate =
the =C2=A0"Context-switch
storm" in the =C2=A0your old version PostgreSQL <st1:chsdate =
IsROCDate=3D"False"
IsLunarDate=3D"False" Day=3D"30" Month=3D"12" Year=3D"1899" =
w:st=3D"on">8.1.15</st1:chsdate>
?<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0 level1 =
lfo1'><![if !supportLists]><font
size=3D2 color=3Dblack face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US =
style=3D'font-size:10.0pt;color:black'><span
style=3D'mso-list:Ignore'>2=E3=80=81<font size=3D1 face=3D"Times New =
Roman"><span
style=3D'font:7.0pt "Times New Roman"'> =
</span></font></span></span></font><![endif]><font
color=3Dblack><span lang=3DEN-US style=3D'color:black'>If you can ,could =
you please
tell me your test case </span>=EF=BC=9F<span =
lang=3DEN-US><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dblack =
face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US
style=3D'font-size:12.0pt;color:black'><o:p> </o:p></span></font></p=
>
<p class=3DMsoNormal style=3D'margin-left:18.0pt'><font size=3D3 =
color=3Dblack face=3D=E5=AE=8Bä=BD=93><span
lang=3DEN-US style=3D'font-size:12.0pt;color:black'>Thank you so =
much</span>=EF=BC=81<span
lang=3DEN-US><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dblack =
face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US
style=3D'font-size:12.0pt;color:black'><o:p> </o:p></span></font></p=
>
<p class=3DMsoNormal><font size=3D3 color=3Dblack =
face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US
style=3D'font-size:12.0pt;color:black'>Best =
regards,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dblack =
face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US
style=3D'font-size:12.0pt;color:black'>Ray =
Huang<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy =
face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US
style=3D'font-size:12.0pt;color:navy'><o:p> </o:p></span></font></p>=
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D=E5=AE=8Bä=BD=93><span lang=3DEN-US style=3D'font-size:12.0pt'>
<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 face=3D=E5=AE=8Bä=BD=93><span =
style=3D'font-size:10.0pt;
font-weight:bold'>=E5=8F=91ä=BB=B6ä=BA=BA<span =
lang=3DEN-US>:</span></span></font></b><font size=3D2><span
lang=3DEN-US style=3D'font-size:10.0pt'> I=C3=B1igo Martinez Lasala
[mailto:imartinez [at] vectorsf.com] <br>
</span></font><b><font size=3D2><span =
style=3D'font-size:10.0pt;font-weight:bold'>=E5=8F=91=E9=80= 81=E6=97=B6=E9=
=97=B4<span
lang=3DEN-US>:</span></span></font></b><font size=3D2><span lang=3DEN-US
style=3D'font-size:10.0pt'> <st1:chsdate IsROCDate=3D"False" =
IsLunarDate=3D"False"
Day=3D"28" Month=3D"5" Year=3D"2010" w:st=3D"on">2010<span =
lang=3DEN-US><span lang=3DEN-US>=E5=B9=B45</span></span><span
lang=3DEN-US><span lang=3DEN-US>=E6=9C=8828</span></span><span =
lang=3DEN-US><span
lang=3DEN-US>=E6=97=A5</span></span></st1:chsdate> 15:43<br>
</span></font><b><font size=3D2><span =
style=3D'font-size:10.0pt;font-weight:bold'>=E6=94=B6ä=BB= B6ä=BA=BA<s=
pan
lang=3DEN-US>:</span></span></font></b><font size=3D2><span lang=3DEN-US
style=3D'font-size:10.0pt'> </span></font><font size=3D2><span =
style=3D'font-size:
10.0pt'>=E9=BB=84=E6=B0=B8=E5=8D=AB<span lang=3DEN-US><br>
</span><b><span style=3D'font-weight:bold'>=E6=8A=84=E9=80=81<span =
lang=3DEN-US>:</span></span></b><span
lang=3DEN-US> pgsql-admin<br>
</span><b><span style=3D'font-weight:bold'>ä=B8=BB=E9=A2=98<span =
lang=3DEN-US>:</span></span></b><span
lang=3DEN-US> Re: About "Context-switch storm" =
problem</span></span></font><span
lang=3DEN-US><o:p></o:p></span></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D=E5=AE=8Bä=BD=93><span =
lang=3DEN-US =
style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D3 =
face=3D=E5=AE=8Bä=BD=93><span
lang=3DEN-US style=3D'font-size:12.0pt'>Hi, Yongwei<br>
<br>
We finally upgraded our database server to last PostgreSQL 8.2 =
available.<br>
<br>
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. <br>
<br>
Migrating to 8.3 or 8.4 is another history. So, my recommendation is to =
migrate
to <st1:chsdate IsROCDate=3D"False" IsLunarDate=3D"False" Day=3D"30" =
Month=3D"12"
Year=3D"1899" w:st=3D"on">8.2.17<br>
<br>
</st1:chsdate>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From</span></b>: =
</span>=E9=BB=84=E6=B0=B8=E5=8D=AB<span lang=3DEN-US>
<<a
href=3D"mailto:%3d%3fUTF-8%3fQ%3f%3dE9%3dBB%3d84%3dE6%3dB0%3 dB8%3dE5%3d8D=
%3dAB%3f%3d%20%3cyongwei.huang [at] gmail.com%3e">yongwei.huang [at] g mail.com</a>&=
gt;<br>
<b><span style=3D'font-weight:bold'>To</span></b>: <a
href=3D"mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.co m</a><br>
<b><span style=3D'font-weight:bold'>Subject</span></b>: About
"Context-switch storm" problem<br>
<b><span style=3D'font-weight:bold'>Date</span></b>: Fri, 28 May 2010 =
13:31:54
+0800<br>
<br>
</span></font><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'>Hello</span></font><font color=3Dnavy><span =
style=3D'color:navy'>=EF=BC=8C<span
lang=3DEN-US>I=C3=B1igo Martinez Lasala !</span></span></font><span =
lang=3DEN-US><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'> </span></font><span lang=3DEN-US><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'>I read your mail about =E2=80=9CContext-switch storm in =
8.<st1:chmetcnv
TCSC=3D"0" NumberType=3D"1" Negative=3D"False" HasSpace=3D"False" =
SourceValue=3D"1.15"
UnitName=3D"=E2=80=9D" w:st=3D"on">1.15=E2=80=9D</st1:chmetcnv> from =
postgres website.</span></font><span
lang=3DEN-US><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'>I think I meet the same problem as you now =
..</span></font><span
lang=3DEN-US><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'>Recently my =
company=E2=80=99s postgres
DB server sluggish suddenly with a hight Context-switching value as =
below:</span></font><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'> </span></font><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'>2010-04-07 04:03:15
procs &n=
bsp;
memory
swap io =
system &=
nbsp;
cpu</span></font><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'>2010-04-07 04:03:15 =
r
b swpd free buff =
cache
si so bi bo
in cs us sy id wa</span></font><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'>2010-04-07 14:04:27 =
3
0 0 2361272 272684 =
3096148
0 0 3 1445 973
14230 7 8 84 0</span></font><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'>2010-04-07 14:05:27 =
2
0 0 2361092 272684 =
3096220
0 0 3 1804 1029 =
31852 8
10 81 1</span></font><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'>2010-04-07 14:06:27 =
1
0 0 2362236 272684 =
3096564
0 0 3 1865 1135 =
19689
9 9 81 0</span></font><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'>2010-04-07 14:07:27 =
1
0 0 2348400 272720 =
3101836
0 0 3 1582 1182 149461 =
15 17
67 0</span></font><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'>2010-04-07 14:08:27 =
3
0 0 2392028 272840 =
3107600
0 0 3 3093 1275 203196 =
24 23
53 1</span></font><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'>2010-04-07 14:09:27 =
3
1 0 2386224 272916 =
3107960
0 0 3 2486 1331 193299 =
26 22
52 0</span></font><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'>2010-04-07 14:10:27 =
34
0 0 2332320 272980 =
3107944
0 0 3 1692 1082 214309 =
24 22
54 0</span></font><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'>2010-04-07 14:11:27 =
1
0 0 2407432 273028 =
3108092
0 0 6 2770 1540 76643 29 =
13
57 1</span></font><br>
<br>
<font color=3Dnavy><span style=3D'color:navy'>2010-04-07 14:12:27 =
9
0 0 2358968 273104 =
3108388
0 0 7 2639 1466 10603 =
22
6 72 1</span></font><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'> </span></font><span lang=3DEN-US><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'> </span></font><span lang=3DEN-US><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'>I</span></font><span lang=3DEN-US><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'>May I know your solution after that =
?</span></font><span
lang=3DEN-US><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'> </span></font><span lang=3DEN-US><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'> </span></font><span lang=3DEN-US><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'> </span></font><span lang=3DEN-US><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'>Thank you !</span></font><span lang=3DEN-US><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'>Best wishes,</span></font><span lang=3DEN-US><br>
<br>
</span><font size=3D2 color=3Dnavy><span lang=3DEN-US =
style=3D'font-size:10.0pt;
color:navy'>Ray Huang</span></font><span lang=3DEN-US><br>
<br>
<br>
<o:p></o:p></span></p>
</div>
</body>
</html>
------=_NextPart_000_0050_01CB00AE.2C5C5830--
