Re: [HACKERS] posmaster failed under high load

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: [HACKERS] posmaster failed under high load
Дата
в 20:26:52
Msg-id
7398.925950324@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
posmaster failed under high load Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] posmaster failed under high load Tatsuo Ishii <t-ishii@sra.co.jp>
Re: [HACKERS] posmaster failed under high load Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] posmaster failed under high load Tatsuo Ishii <t-ishii@sra.co.jp>
Re: [HACKERS] posmaster failed under high load Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] posmaster failed under high load Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] posmaster failed under high load Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] posmaster failed under high load Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] posmaster failed under high load Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] posmaster failed under high load Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] posmaster failed under high load Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] posmaster failed under high load Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] posmaster failed under high load Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] posmaster failed under high load Taral <taral@taral.net>
Re: [HACKERS] posmaster failed under high load Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] posmaster failed under high load Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] posmaster failed under high load Taral <taral@taral.net>
Re: [HACKERS] posmaster failed under high load Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] posmaster failed under high load Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] posmaster failed under high load Oleg Broytmann <phd@sun.med.ru>
Re: [HACKERS] posmaster failed under high load Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] posmaster failed under high load Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] posmaster failed under high load Tom Lane <tgl@sss.pgh.pa.us>
I wrote:
> Oleg Bartunov  writes:
>> It's interesting, that process with pid 701 migrates from 
>> (postmaster) to postgres with normal ps output !

> Yes, that's pretty strong evidence in favor of my theory (that these
> processes are just new backends that haven't received a command yet).

Nope, that theory is all wet --- the backend definitely does 
PS_SET_STATUS("idle") before it waits for a query.  Something is
*really* peculiar here, since your backtrace shows that the backend
has reached the point of waiting for client input.  It is not possible
to get there without having done PS_SET_STATUS.  So why does the process
still show up as "(postmaster)" in ps?  Something is flaky about your
system's support of ps status setting, I think.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Taral
Дата:
FAQ