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黄永卫)
Список: pgsql-performance

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

От: Bruce Momjian
Дата:
Сообщение: Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
От: norn
Дата:
Сообщение: Re: significant slow down with various LIMIT