Re: [HACKERS] posmaster failed under high load

Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
>> I'm not sure what would block a new backend for many minutes before
>> it did that, however. Can you attach to one of these processes with
>> a debugger and get a backtrace to show what it's doing?

> Below some output from ps and attached backtrace of one postmaster
> process.

Hmm, that backend is quite obviously done with initialization and
waiting for a client command. So why doesn't it show up as
"postgres ... idle" in ps?

I wonder whether we have the ps-info-setting operation in the wrong
place, ie at the bottom of the loop instead of the top, so that a
backend that hasn't yet received its first client command will never
have set the ps data. Will take a look.

regards, tom lane