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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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