Re: Postmaster taking 100% of the CPU

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Kerr <dmk(at)mr-paradox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postmaster taking 100% of the CPU
Date: 2009-10-26 20:38:51
Message-ID: 15385.1256589531@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Kerr <dmk(at)mr-paradox(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Kerr 2009-10-26 20:44:11 Re: Postmaster taking 100% of the CPU
Previous Message Dave Page 2009-10-26 20:15:50 Re: [ANNOUNCE] PGDay.EU 2009 - approaching fast!