Re: Occasional giant spikes in CPU load

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: David Rees <drees76(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Occasional giant spikes in CPU load
Date: 2010-04-08 06:08:05
Message-ID: 4BBD72C5.8060204@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

David Rees wrote:
> You need to find out what all those Postgres processes are doing. You
> might try enabling update_process_title and then using ps to figure
> out what each instance is using.

That's what the addition of "-c" to top I suggested does on Linux; it
shows the updated process titles where the command line is in the
default config.

--
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 Greg Smith 2010-04-08 06:13:32 Re: 3ware vs. MegaRAID
Previous Message Dave Crooke 2010-04-08 03:44:09 Re: 3ware vs. MegaRAID