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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-bugs-owner(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org>, RD黄永卫 <yongwei_huang(at)temp(dot)gtmc(dot)com(dot)cn>
Subject: Re: How to diagnose a *context-switching * storm problem ?
Date: 2010-04-12 21:39:48
Message-ID: 4BC34CD40200002500030765@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

RD黄永卫<yongwei_huang(at)temp(dot)gtmc(dot)com(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2010-04-13 02:49:29 Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
Previous Message Kevin Grittner 2010-04-12 21:28:36 Re: significant slow down with various LIMIT