pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAbout 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