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

From Tom Lane
Subject Re: Postmaster taking 100% of the CPU
Date
Msg-id 15385.1256589531@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postmaster taking 100% of the CPU  (David Kerr <dmk@mr-paradox.net>)
Responses Re: Postmaster taking 100% of the CPU
List pgsql-general
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

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: [ANNOUNCE] [pgeu-general] PGDay.EU 2009 - approaching fast!
Next
From: David Kerr
Date:
Subject: Re: Postmaster taking 100% of the CPU