Re: Idle postmaster taking up a lot of CPU

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