Re: Occasional giant spikes in CPU load - Mailing list pgsql-performance

From Greg Smith
Subject Re: Occasional giant spikes in CPU load
Date
Msg-id 4C2402C3.6080209@2ndquadrant.com
Whole thread Raw
In response to Re: Occasional giant spikes in CPU load  (Craig James <craig_james@emolecules.com>)
List pgsql-performance
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
greg@2ndQuadrant.com   www.2ndQuadrant.us


pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Occasional giant spikes in CPU load
Next
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL as a local in-memory cache