Re: Postmaster taking up 100% of CPU

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: higeon <higeon(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postmaster taking up 100% of CPU
Date: 2010-07-06 14:32:58
Message-ID: 4C333E9A.5060600@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)2ndQuadrant(dot)com www.2ndQuadrant.us

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2010-07-06 14:48:48 Re: Change to 'timing on' globally
Previous Message Tom Lane 2010-07-06 14:25:17 Re: "Localizing" paths?