Craig James wrote:
> Now the question has narrowed down to this: what could trigger EVERY
> postgres backend to do something at the same time? See the attached
> output from "top -b", which shows what is happening during one of the
> CPU spikes.
By the way: you probably want "top -b -c", which will actually show you
what each client is doing via inspecting what it's set its command line to.
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
In response to
pgsql-performance by date
|Next:||From: Robert Haas||Date: 2010-06-25 03:05:06|
|Subject: Re: requested shared memory size overflows size_t|
|Previous:||From: Joshua D. Drake||Date: 2010-06-25 01:01:40|
|Subject: Re: Occasional giant spikes in CPU load|