Re: RESOLVED: Re: Wierd context-switching issue on Xeon

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: RESOLVED: Re: Wierd context-switching issue on Xeon
Дата
Msg-id 200404160958.14902.josh@agliodbs.com
обсуждение исходный текст
Ответ на RESOLVED: Re: Wierd context-switching issue on Xeon  (Dirk Lutzebäck <lutzeb@aeccom.com>)
Ответы Re: RESOLVED: Re: Wierd context-switching issue on Xeon
Список pgsql-performance
Dirk,

> I'm not sure if this semop() problem is still an issue but the database
> behaves a bit out of bounds in this situation, i.e. consuming system
> resources with semop() calls 95% while tables are locked very often and
> longer.

It would be helpful to us if you could test this with the indexes disabled on
the non-Bigmem system.   I'd like to eliminate Bigmem as a factor, if
possible.

--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
    Enterprise vertical business        josh@agliodbs.com
     and data analysis solutions        (415) 752-2387
      and database optimization           fax 651-9224
  utilizing Open Source technology      San Francisco


В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Horribly slow hash join
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Index Problem?