Re: [GENERAL] postmaster deadlock while logging after sysloggerexited

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [GENERAL] postmaster deadlock while logging after sysloggerexited
Дата
Msg-id 20171204202320.xaufivj3ik3gaqkh@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [GENERAL] postmaster deadlock while logging after syslogger exited  (David Pacheco <dap@joyent.com>)
Ответы Re: [GENERAL] postmaster deadlock while logging after syslogger exited  (David Pacheco <dap@joyent.com>)
Список pgsql-general
Hi,

On 2017-11-20 11:12:08 -0800, David Pacheco wrote:
> $ ps -opid,rss,vsz,args -p 37627
>   PID  RSS  VSZ COMMAND
> 37627 2980 14968 /opt/postgresql/9.2.4/bin/postgres -D /manatee/pg/data
> 
> I'm not sure what we can infer from that, as this is a different system,
> and the workload that generates the very large query strings only runs
> occasionally.  Those strings are also not logged unless something's gone
> wrong.

FWIW, I'd like to see a report of this around the time the issue
occurred before doing anything further here.

Greetings,

Andres Freund


В списке pgsql-general по дате отправления:

Предыдущее
От: David Pacheco
Дата:
Сообщение: Re: [GENERAL] postmaster deadlock while logging after syslogger exited
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Centos 6.9 and centos 7