| From: | David Kerr <dmk(at)mr-paradox(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postmaster taking 100% of the CPU |
| Date: | 2009-10-26 20:44:11 |
| Message-ID: | 20091026204411.GA88654@mr-paradox.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Oct 26, 2009 at 04:38:51PM -0400, Tom Lane wrote:
- 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
-
wow, hmm, if i can't trust linux ps, what can i trust! <cries> =)
Thanks. that would clear it up.
Dave
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Kempter | 2009-10-26 21:03:25 | Re: How do I pipe output from query to a file in PostgreSQL? |
| Previous Message | Tom Lane | 2009-10-26 20:38:51 | Re: Postmaster taking 100% of the CPU |