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: (view raw or whole 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

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-2015 The PostgreSQL Global Development Group