On 1/17/04 12:32 PM, Tom Lane wrote: > 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?
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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
