> 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)
In response to
pgsql-performance by date
|Next:||From: Bruce Momjian||Date: 2010-04-13 02:49:29|
|Subject: Re: *** PROBABLY SPAM *** Does the psql executable
support a "fetch many" approach when dumping large queries to
|Previous:||From: Kevin Grittner||Date: 2010-04-12 21:28:36|
|Subject: Re: significant slow down with various LIMIT|