Re: Postmaster taking 100% of the CPU - Mailing list pgsql-general

From David Kerr
Subject Re: Postmaster taking 100% of the CPU
Date
Msg-id 20091026204411.GA88654@mr-paradox.net
Whole thread Raw
In response to Re: Postmaster taking 100% of the CPU  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, Oct 26, 2009 at 04:38:51PM -0400, Tom Lane wrote:
- David Kerr <dmk@mr-paradox.net> writes:
- > Looks like it was a query that was running. once my developer killed it the CPU went back down.
- > I'm a little surprised by that, the backend process for that developer wasn't taking up a lot of CPU,
- > just the postmaster itself.
-
- The backtrace you showed was most definitely from a backend, not the
- postmaster.  I think you misidentified the process.  On some platforms
- "ps" isn't tremendously helpful about telling them apart ...
-
-             regards, tom lane
-

wow, hmm, if i can't trust linux ps, what can i trust! <cries> =)

Thanks. that would clear it up.

Dave

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postmaster taking 100% of the CPU
Next
From: "Penrod, John"
Date:
Subject: How do I pipe output from query to a file in PostgreSQL?