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

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

In response to

Browse pgsql-performance by date

  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