Postgres Pro
Downloads
Home   >   mailing lists

Re: How to diagnose a *context-switching * storm problem ? - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: How to diagnose a *context-switching * storm problem ?
Date
Msg-id 4BC34CD40200002500030765@gw.wicourts.gov
Whole thread Raw
In response to How to diagnose a “context-switching ” storm problem ?  (RD黄永卫 <yongwei_huang@temp.gtmc.com.cn>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: significant slow down with various LIMIT
Next
From: Bruce Momjian
Date:
Subject: Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?