Skip site navigation (1) Skip section navigation (2)

Re: Occasional giant spikes in CPU load

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Occasional giant spikes in CPU load
Date: 2010-06-25 01:13:39
Message-ID: 4C2402C3.6080209@2ndquadrant.com (view raw or flat)
Thread:
Lists: 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(at)2ndQuadrant(dot)com   www.2ndQuadrant.us


In response to

pgsql-performance by date

Next:From: Robert HaasDate: 2010-06-25 03:05:06
Subject: Re: requested shared memory size overflows size_t
Previous:From: Joshua D. DrakeDate: 2010-06-25 01:01:40
Subject: Re: Occasional giant spikes in CPU load

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group