答复: [PERFORM] About Tom Lane's Xeon CS test case - Mailing list pgsql-performance

From 黄永卫
Subject 答复: [PERFORM] About Tom Lane's Xeon CS test case
Date
Msg-id E6B84BD2A3F84FA4B9A9406F1D7404C2@NECSLGZ0061411
Whole thread Raw
In response to Re: About Tom Lane's Xeon CS test case  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@sss.pgh.pa.us]
发送时间: 2010年5月27日 22:10
收件人: 黄永卫
抄送: pgsql-performance@postgresql.org
主题: Re: [PERFORM] About Tom Lane's Xeon CS test case

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


pgsql-performance by date:

Previous
From: Krzysztof Nienartowicz
Date:
Subject: Re: [BUGS] Query causing explosion of temp space with join involving partitioning
Next
From: Torsten Zühlsdorff
Date:
Subject: How to insert a bulk of data with unique-violations very fast