Re: [GENERAL] postmaster deadlock while logging after sysloggerexited - Mailing list pgsql-general

From Andres Freund
Subject Re: [GENERAL] postmaster deadlock while logging after sysloggerexited
Date
Msg-id 20171204202320.xaufivj3ik3gaqkh@alap3.anarazel.de
Whole thread Raw
In response to Re: [GENERAL] postmaster deadlock while logging after syslogger exited  (David Pacheco <dap@joyent.com>)
Responses Re: [GENERAL] postmaster deadlock while logging after syslogger exited
List 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 by date:

Previous
From: David Pacheco
Date:
Subject: Re: [GENERAL] postmaster deadlock while logging after syslogger exited
Next
From: Alban Hertroys
Date:
Subject: Re: Centos 6.9 and centos 7