Re: sblock state on FreeBSD 6.1

Jim C. Nasby wrote:

> Yeah, my suspicion is that those processes had moved past waiting on the
> socket lock by the time gdb got to them. Any idea of how you could tell
> what state (as reported by top) the process was in when gdb stopped it?

I think you could send SIGSTOP to all backends at once, then grab the
backtraces with GDB, then restart them.  That way, all backends will
appear to be in the same frozen state, instead of having some in an
"earlier" state than others.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.