Re: About "Context-switch storm" problem

Re: About "Context-switch storm" problem

am 28.05.2010 09:43:04 von imartinez

--=-5DIsr7vHa/4tSaWwSP95
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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.=20

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

-----Original Message-----
From: 黄永å=AB
To: imartinez@vectorsf.com
Subject: About "Context-switch storm" problem
Date: Fri, 28 May 2010 13:31:54 +0800

Helloï¼=8CIñigo Martinez Lasala !

=20

I read your mail about â€=9CContext-switch storm in 8.1.15â€=9D f=
rom postgres
website.

I think I meet the same problem as you now .

Recently my companyâ€=99s postgres DB server sluggish suddenly with =
a hight
Context-switching value as below:

=20

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

=20

=20

I

May I know your solution after that ?

=20

=20

=20

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: 黄永卫 <>

To:

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--

答复: About "Context-switch storm"

am 31.05.2010 04:43:55 von yongwei.huang

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ñigo Martinez Lasalaï¼=8C

Thank you for your replay and advice.=20

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 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 several questions?

=20

1ã€=81 Can you recreate the "Context-switch storm" in the your =
old version PostgreSQL 8.1.15 ?

2ã€=81 If you can ,could you please tell me your test case =
ï¼=9F

=20

Thank you so muchï¼=81

=20

Best regards,

Ray Huang

=20

_____ =20

发件äº=BA: Iñigo Martinez Lasala =
[mailto:imartinez@vectorsf.com]=20
发送时间: 2010å¹=B45æœ=8828æ—=A5 =
15:43
收件äº=BA: 黄永å=AB
抄送: pgsql-admin
主题: Re: About "Context-switch storm" problem

=20

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.=20

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

-----Original Message-----
From: 黄永å=AB f%3d%20%3cyongwei.huang@gmail.com%3e> >
To: imartinez@vectorsf.com
Subject: About "Context-switch storm" problem
Date: Fri, 28 May 2010 13:31:54 +0800

Helloï¼=8CIñigo Martinez Lasala !

=20

I read your mail about â€=9CContext-switch storm in 8.1.15â€=9D =
from postgres website.

I think I meet the same problem as you now .

Recently my companyâ€=99s postgres DB server sluggish suddenly with =
a hight Context-switching value as below:

=20

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

=20

=20

I

May I know your solution after that ?

=20

=20

=20

Thank you !

Best wishes,

Ray Huang





------=_NextPart_000_0050_01CB00AE.2C5C5830
Content-Type: text/html;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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">




namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"chsdate"/>
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"chmetcnv"/>









face=宋ä½=93> style=3D'font-size:12.0pt;color:black'>Dear Iñigo Martinez =
Lasala
ï¼=8C lang=3DEN-US>



face=宋ä½=93> style=3D'font-size:12.0pt;color:black'>    Thank you for =
your replay and advice.



style=3D'margin-left:18.0pt;text-indent:6.0pt'> color=3Dblack face=宋ä½=93> style=3D'font-size:12.0pt;color:black'>My
company is a software application vendor, and our =
customer  is
useing
PostgreSQL IsLunarDate=3D"False"
Day=3D"30" Month=3D"12" Year=3D"1899" =
w:st=3D"on">8.1.3
.



color=3Dblack face=宋ä½=93> lang=3DEN-US style=3D'font-size:12.0pt;color:black'>When our application =
is runing
, the DB sluggish suddenly and application =
stop.



color=3Dblack face=宋ä½=93> lang=3DEN-US style=3D'font-size:12.0pt;color:black'>To href=3D"javascript:;"> color=3Dblack> style=3D'color:black;text-decoration:none'>prove 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.



face=宋ä½=93> style=3D'font-size:12.0pt;color:black'>    And Can =
 I ask you   href=3D"javascript:;"> style=3D'color:black;text-decoration:
none'>several
  =
questions?



face=宋ä½=93> style=3D'font-size:12.0pt;color:black'>  >

style=3D'margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0 level1 =
lfo1'> size=3D2 color=3Dblack face=宋ä½=93> style=3D'font-size:10.0pt;color:black'> style=3D'mso-list:Ignore'>1ã€=81 Roman"> style=3D'font:7.0pt "Times New Roman"'>  =
color=3Dblack>Can you recreate =
the  "Context-switch
storm" in the  your old version PostgreSQL IsROCDate=3D"False"
IsLunarDate=3D"False" Day=3D"30" Month=3D"12" Year=3D"1899" =
w:st=3D"on">8.1.15

?



style=3D'margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0 level1 =
lfo1'> size=3D2 color=3Dblack face=宋ä½=93> style=3D'font-size:10.0pt;color:black'> style=3D'mso-list:Ignore'>2ã€=81 Roman"> style=3D'font:7.0pt "Times New Roman"'>  =
color=3Dblack>If you can ,could =
you please
tell me your test case
ï¼=9F lang=3DEN-US>



face=宋ä½=93> style=3D'font-size:12.0pt;color:black'>  >

color=3Dblack face=宋ä½=93> lang=3DEN-US style=3D'font-size:12.0pt;color:black'>Thank you so =
muchï¼=81 lang=3DEN-US>



face=宋ä½=93> style=3D'font-size:12.0pt;color:black'>  >

face=宋ä½=93> style=3D'font-size:12.0pt;color:black'>Best =
regards,



face=宋ä½=93> style=3D'font-size:12.0pt;color:black'>Ray =
Huang



face=宋ä½=93> style=3D'font-size:12.0pt;color:navy'> 

=




size=3D3
face=宋ä½=93>






style=3D'font-size:10.0pt;
font-weight:bold'>发件äº=BA lang=3DEN-US>:
lang=3DEN-US style=3D'font-size:10.0pt'> Iñigo Martinez Lasala
[mailto:imartinez@vectorsf.com]

style=3D'font-size:10.0pt;font-weight:bold'>发é=80= 81时é=
—´ lang=3DEN-US>:
style=3D'font-size:10.0pt'> IsLunarDate=3D"False"
Day=3D"28" Month=3D"5" Year=3D"2010" w:st=3D"on">2010 lang=3DEN-US>å¹=B45 lang=3DEN-US>æœ=8828
lang=3DEN-US> lang=3DEN-US>æ—=A5 15:43

style=3D'font-size:10.0pt;font-weight:bold'>收ä=BB= B6äº=BA pan
lang=3DEN-US>:
style=3D'font-size:10.0pt'> style=3D'font-size:
10.0pt'>黄永å=AB

抄送 lang=3DEN-US>: lang=3DEN-US> pgsql-admin

主题 lang=3DEN-US>: lang=3DEN-US> Re: About "Context-switch storm" =
problem
lang=3DEN-US>





lang=3DEN-US =
style=3D'font-size:12.0pt'> 



face=宋ä½=93> lang=3DEN-US style=3D'font-size:12.0pt'>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 Month=3D"12"
Year=3D"1899" w:st=3D"on">8.2.17



-----Original Message-----

From: =
黄永å=AB
< href=3D"mailto:%3d%3fUTF-8%3fQ%3f%3dE9%3dBB%3d84%3dE6%3dB0%3 dB8%3dE5%3d8D=
%3dAB%3f%3d%20%3cyongwei.huang@gmail.com%3e">yongwei.huang@g mail.com&=
gt;

To: href=3D"mailto:imartinez@vectorsf.com">imartinez@vectorsf.co m

Subject: About
"Context-switch storm" problem

Date: Fri, 28 May 2010 =
13:31:54
+0800



style=3D'font-size:10.0pt;
color:navy'>Hello
style=3D'color:navy'>ï¼=8C lang=3DEN-US>Iñigo Martinez Lasala ! lang=3DEN-US>



style=3D'font-size:10.0pt;
color:navy'>   




style=3D'font-size:10.0pt;
color:navy'>I read your mail about â€=9CContext-switch storm in =
8. TCSC=3D"0" NumberType=3D"1" Negative=3D"False" HasSpace=3D"False" =
SourceValue=3D"1.15"
UnitName=3D"â€=9D" w:st=3D"on">1.15â€=9D from =
postgres website.
lang=3DEN-US>



style=3D'font-size:10.0pt;
color:navy'>I think I meet the same problem as you now =
..
lang=3DEN-US>



Recently my =
companyâ€=99s  postgres
DB server sluggish suddenly with a hight Context-switching value as =
below:




 



2010-04-07 04:03:15
procs           &n=
bsp;         
memory     
swap          io =
    system       &=
nbsp;
cpu




2010-04-07 04:03:15  =

b   swpd   free   buff  =
cache  
si   so    bi    bo  
in    cs us sy id wa




2010-04-07 14:04:27  =

0      0 2361272 272684 =
3096148   
0    0     3  1445  973
14230  7  8 84  0




2010-04-07 14:05:27  =

0      0 2361092 272684 =
3096220   
0    0     3  1804 1029 =
31852  8
10 81  1




2010-04-07 14:06:27  =

0      0 2362236 272684 =
3096564   
0    0     3  1865 1135 =
19689 
9  9 81  0




2010-04-07 14:07:27  =

0      0 2348400 272720 =
3101836   
0    0     3  1582 1182 149461 =
15 17
67  0




2010-04-07 14:08:27  =

0      0 2392028 272840 =
3107600   
0    0     3  3093 1275 203196 =
24 23
53  1




2010-04-07 14:09:27  =

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  =

0      0 2407432 273028 =
3108092   
0    0     6  2770 1540 76643 29 =
13
57  1




2010-04-07 14:12:27  =

0      0 2358968 273104 =
3108388   
0    0     7  2639 1466 10603 =
22 
6 72  1




style=3D'font-size:10.0pt;
color:navy'> 




style=3D'font-size:10.0pt;
color:navy'> 




style=3D'font-size:10.0pt;
color:navy'>I




style=3D'font-size:10.0pt;
color:navy'>May I know your solution after  that =
?
lang=3DEN-US>



style=3D'font-size:10.0pt;
color:navy'> 




style=3D'font-size:10.0pt;
color:navy'> 




style=3D'font-size:10.0pt;
color:navy'> 




style=3D'font-size:10.0pt;
color:navy'>Thank you !




style=3D'font-size:10.0pt;
color:navy'>Best wishes,




style=3D'font-size:10.0pt;
color:navy'>Ray Huang














------=_NextPart_000_0050_01CB00AE.2C5C5830--