John Siracusa <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to