Re: Idle postmaster taking up a lot of CPU

On 1/17/04 12:32 PM, Tom Lane wrote:
> John Siracusa <siracusa(at)mindspring(dot)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?

This is Postgres 7.4.0 on:

% uname -a
Linux foo.com 2.4.22 #5 SMP Fri Oct 10 16:32:42 EDT 2003 i686 i686 i386
GNU/Linux

> 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

Will do.

-John