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: | Raw Message | Whole Thread | 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 |