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黄永卫 <yongwei_huang@temp.gtmc.com.cn>)
Список pgsql-performance
RD黄永卫<yongwei_huang@temp.gtmc.com.cn> 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"
Дата:
Сообщение: Re: significant slow down with various LIMIT
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?