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

От: 黄永卫
Тема: 答复: [PERFORM] About Tom Lane's Xeon CS test case
Дата: ,
Msg-id: E6B84BD2A3F84FA4B9A9406F1D7404C2@NECSLGZ0061411
(см: обсуждение, исходный текст)
Ответ на: Re: About Tom Lane's Xeon CS test case  (Tom Lane)
Список: 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:]
发送时间: 2010年5月27日 22:10
收件人: 黄永卫
抄送: 
主题: Re: [PERFORM] About Tom Lane's Xeon CS test case

=?gb2312?B?u8bTwM7A?= <> 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 по дате сообщения:

От: Bob Lunney
Дата:
Сообщение: Re: SELECT ignoring index even though ORDER BY and LIMIT present
От: Joshua Tolley
Дата:
Сообщение: Re: requested shared memory size overflows size_t