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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: RESOLVED: Re: Wierd context-switching issue on Xeon
Дата
Msg-id 28603.1082123378@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RESOLVED: Re: Wierd context-switching issue on Xeon  (Dirk Lutzebäck <lutzeb@aeccom.com>)
Список pgsql-performance
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@aeccom.com> writes:
> This was the key to look at: we were missing all indices on table which
> is used heavily and does lots of locking. After recreating the missing
> indices the production system performed normal. No, more excessive
> semop() calls, load way below 1.0, CS over 20.000 very rare, more in
> thousands realm and less.

Hmm ... that's darn interesting.  AFAICT the test case I am looking at
for Josh's client has no such SQL-level problem ... but I will go back
and double check ...

            regards, tom lane

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

Предыдущее
От: "Shea,Dan [CIS]"
Дата:
Сообщение: Re: [ SOLVED ] select count(*) very slow on an already
Следующее
От: Tom Lane
Дата:
Сообщение: Re: query slows down with more accurate stats