pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
About Tom Lane's Xeon CS test case
2+ messages / 2 participants
[nested] [flat]

* About Tom Lane's Xeon CS test case
@ 2010-05-27 07:27  黄永卫 <yongwei.huang@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: 黄永卫 @ 2010-05-27 07:27 UTC (permalink / raw)
  To: tgl@sss.pgh.pa.us; pgsql-performance

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: About Tom Lane's Xeon CS test case
@ 2010-05-27 14:09  Tom Lane <tgl@sss.pgh.pa.us>
  parent: 黄永卫 <yongwei.huang@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2010-05-27 14:09 UTC (permalink / raw)
  To: 黄永卫 <yongwei.huang@gmail.com>; +Cc: pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2010-05-27 14:09 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-05-27 07:27 About Tom Lane's Xeon CS test case 黄永卫 <yongwei.huang@gmail.com>
2010-05-27 14:09 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox