Re: checkpointer and other server processes crashing - Mailing list pgsql-general

From Joe Abbate
Subject Re: checkpointer and other server processes crashing
Date
Msg-id 90ca83ee-7add-2980-6962-f998336dbf5d@freedomcircle.com
Whole thread Raw
In response to Re: checkpointer and other server processes crashing  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: checkpointer and other server processes crashing
List pgsql-general
On 15/2/21 16:29, Adrian Klaver wrote:
> On 2/15/21 1:15 PM, Joe Abbate wrote:
>> We've been experiencing PG server process crashes about every other 
>> week on a mostly read only website (except for a single insert/update 
>> on page access).  Typical log entries look like
>>
>> LOG:  checkpointer process (PID 11200) was terminated by signal 9: Killed
>> LOG:  terminating any other active server processes
> 
> Have you looked at the system logs to see if the OOM killer is involved?

No, I hadn't, but now I see that of the past three crashes, four 
postgres processes were OOM victims.  I guess I have to read the OOM 
articles I've been skipping (read one a long time ago).  If you have any 
specific suggestions, let me know.

Thanks Adrian,

Joe



pgsql-general by date:

Previous
From: Tim Cross
Date:
Subject: Re: checkpointer and other server processes crashing
Next
From: Thomas Munro
Date:
Subject: Re: [LDAPS] Test connection user with ldaps server