From: Greg Smith <greg@2ndquadrant.com>
To: higeon <higeon@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postmaster taking up 100% of CPU
Date: Tue, 06 Jul 2010 15:32:58 +0100
Message-ID: <4C333E9A.5060600@2ndquadrant.com> (raw)
In-Reply-To: <AANLkTilaoyL2RcTu4he-iDU9MKSYATU7qQEWfxopF4l7@mail.gmail.com>
References: <AANLkTilaoyL2RcTu4he-iDU9MKSYATU7qQEWfxopF4l7@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: greg@2ndquadrant.com, higeon@gmail.com
Subject: Re: Postmaster taking up 100% of CPU
In-Reply-To: <4C333E9A.5060600@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox