Re: Postmaster taking 100% of the CPU

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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: [ANNOUNCE] [pgeu-general] PGDay.EU 2009 - approaching fast!
Следующее
От: David Kerr
Дата:
Сообщение: Re: Postmaster taking 100% of the CPU