Postgres Pro
Downloads
Home   >   mailing lists

Re: Postmaster taking up 100% of CPU - Mailing list pgsql-admin

From Greg Smith
Subject Re: Postmaster taking up 100% of CPU
Date
Msg-id 4C333E9A.5060600@2ndquadrant.com
Whole thread Raw
In response to Postmaster taking up 100% of CPU  (higeon <higeon@gmail.com>)
List pgsql-admin
Tree view 
higeon wrote:
> The following is my top log and ps log:

Try using "top -c" on Linux instead.  Then you'll be able to see what
all the processes are doing.  Any heavy query will cause a CPU to
consume 100% of its time when running, so there may be nothing wrong
other than you have queries to optimize better.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us

pgsql-admin by date:

Previous
From: higeon
Date:
Subject: Postmaster taking up 100% of CPU
Next
From: Bruce Momjian
Date:
Subject: Re: Change to 'timing on' globally