Re: How to diagnose a *context-switching * storm problem ?

Поиск
Список
Период
Сортировка
Искать
От
Kevin Grittner
Тема
Re: How to diagnose a *context-switching * storm problem ?
Дата
Msg-id
4BC34CD40200002500030765@gw.wicourts.gov
Ответ на
How to diagnose a “context-switching ” storm problem ? (RD黄永卫)
Список
Дерево обсуждения
How to diagnose a “context-switching ” storm problem ? RD黄永卫 <yongwei_huang@temp.gtmc.com.cn>
Re: How to diagnose a *context-switching * storm problem ? "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: [PERFORM] How to diagnose a “context-switching ” storm problem ? Sergey Konoplev <gray.ru@gmail.com> 
RD黄永卫 wrote: 
 
> My database server get sluggish suddenly
 
> [vmstat output showing over 200,000 context switches per second]
 
>    My postgres version: 8.1.3;
 
Upgrading should help.  Later releases are less vulnerable to this.
 
> Could you please give me some advice ?
 
A connection pooler can often help.  (e.g., pgpool or pgbouncer)
 
-Kevin
В списке pgsql-performance по дате отправления
Предыдущее
От: Kevin Grittner
Дата:
Следующее
От: Bruce Momjian
Дата:
FAQ