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