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 4BBD72C5.8060204@2ndquadrant.com
Whole thread Raw
In response to Re: Occasional giant spikes in CPU load  (David Rees <drees76@gmail.com>)
List 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@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: Greg Smith
Date:
Subject: Re: 3ware vs. MegaRAID