Thread: About Tom Lane's Xeon CS test case

About Tom Lane's Xeon CS test case

From
黄永卫
Date:

Dear all and Tom

    Recently my companys  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 companys 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

Re: About Tom Lane's Xeon CS test case

From
Tom Lane
Date:
=?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

答复: [PERFORM] About Tom Lane's Xeon CS test case

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