Re: Idle postmaster taking up a lot of CPU

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Idle postmaster taking up a lot of CPU
Дата
Msg-id 16686.1074360753@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Idle postmaster taking up a lot of CPU  (John Siracusa <siracusa@mindspring.com>)
Ответы Re: Idle postmaster taking up a lot of CPU  (John Siracusa <siracusa@mindspring.com>)
Список pgsql-performance
John Siracusa <siracusa@mindspring.com> writes:
> Process 20753 was hovering around 60-70% CPU usage for a long time.

> I tried to see what that postmaster was doing, but it appeared to be "idle"

> % ps -wwwx -p 20753
>   PID TTY      STAT   TIME COMMAND
> 20753 pts/3    R     26:59 postgres: postgres pdm 192.168.0.35 idle

That seems odd to me too.  What PG version is this exactly?

If it happens again, please see if you can get a stack trace from the
not-so-idle process:

    $ gdb /path/to/postgres-executable
    gdb> attach PID-of-process
    gdb> bt
    gdb> quit

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: "D'Arcy J.M. Cain"
Дата:
Сообщение: Re: Postgres on Netapp
Следующее
От: John Siracusa
Дата:
Сообщение: Re: Idle postmaster taking up a lot of CPU