Re: checkpointer and other server processes crashing

From: Joe Abbate <jma(at)freedomcircle(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: checkpointer and other server processes crashing
Date: 2021-02-15 21:50:15
Message-ID: 90ca83ee-7add-2980-6962-f998336dbf5d@freedomcircle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Munro 2021-02-15 22:39:03 Re: [LDAPS] Test connection user with ldaps server
Previous Message Tim Cross 2021-02-15 21:47:10 Re: checkpointer and other server processes crashing