Re: Postmaster taking 100% of the CPU

Поиск
Список
Период
Сортировка
От David Kerr
Тема Re: Postmaster taking 100% of the CPU
Дата
Msg-id 20091026204411.GA88654@mr-paradox.net
обсуждение исходный текст
Ответ на Re: Postmaster taking 100% of the CPU  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postmaster taking 100% of the CPU
Следующее
От: "Penrod, John"
Дата:
Сообщение: How do I pipe output from query to a file in PostgreSQL?