Обсуждение: About Tom Lane's Xeon CS test case
Dear all and Tom，
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 have read this problem about ““Tom Lane” Workload” . And I found my company’s DB is a Xeon MP server.
I am going to have a test to confirm it.
If anybody have the test case “Tom Lane's Xeon CS test case” ?
Thank you!
My postgres version: 8.1.3;
My OS version: Linux version 2.4.21-47.Elsmp((Red Hat Linux 3.2.3-54)
My CPU:
processor : 7
vendor_id : GenuineIntel
cpu family : 15
model : 6
model name : Intel(R) Xeon(TM) CPU 3.40GHz
stepping : 8
cpu MHz : 3400.262
cache size : 1024 KB
physical id : 1
Best regards,
Ray Huang
=?gb2312?B?u8bTwM7A?= <yongwei.huang@gmail.com> writes:
> My postgres version: 8.1.3;
You do realize that version was obsoleted four years ago last week?
If you're encountering multiprocessor performance problems you
really need to get onto 8.3.x or later.
regards, tom lane
Tom ,
Thank you for your reply!
I am encountering a context-switch storm problem .
We got the pg_locks data when context-switch value over 200K/sec
We fount that the value of CS relate to the count of
Exclutivelocks .
And I donnt know how to make the problem appear again by testing to
collect evidence to update postgreSQL .
So I want to redo your testing for that.
Thank you！
Best regards，
Ray Huang
-----邮件原件-----
发件人: Tom Lane [mailto:tgl@sss.pgh.pa.us]
发送时间: 2010年5月27日 22:10
收件人: 黄永卫
抄送: pgsql-performance@postgresql.org
主题: Re: [PERFORM] About Tom Lane's Xeon CS test case
=?gb2312?B?u8bTwM7A?= <yongwei.huang@gmail.com> writes:
> My postgres version: 8.1.3;
You do realize that version was obsoleted four years ago last week?
If you're encountering multiprocessor performance problems you
really need to get onto 8.3.x or later.
regards, tom lane