| From: | 黄永卫 <yongwei(dot)huang(at)gmail(dot)com> |
|---|---|
| To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | 答复: [PERFORM] About Tom Lane's Xeon CS test case |
| Date: | 2010-05-28 04:11:31 |
| Message-ID: | E6B84BD2A3F84FA4B9A9406F1D7404C2@NECSLGZ0061411 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)sss(dot)pgh(dot)pa(dot)us]
发送时间: 2010年5月27日 22:10
收件人: 黄永卫
抄送: pgsql-performance(at)postgresql(dot)org
主题: Re: [PERFORM] About Tom Lane's Xeon CS test case
=?gb2312?B?u8bTwM7A?= <yongwei(dot)huang(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Konrad Garus | 2010-05-28 07:57:40 | Re: shared_buffers advice |
| Previous Message | David Jarvis | 2010-05-28 03:29:13 | Re: Random Page Cost and Planner |