Re: checkpointer and other server processes crashing

2021-02-19 Thread Peter J. Holzer
On 2021-02-15 16:15:44 -0500, Joe Abbate wrote: > As I understand it, the PG server processes doing a SELECT are spawned as > children of the Go process, There's a misconception here: The server processes are children of the postmaster process, not of the client program (whether it's written in Go

Re: checkpointer and other server processes crashing

2021-02-19 Thread Peter J. Holzer
On 2021-02-15 15:34:30 -0800, Adrian Klaver wrote: > It probably would not hurt to figure why this seemed to happen with the > Python -> Go switch. Even if you can get the OOM not to kick in, the fact > that it was kicking in would indicate you now have memory hungry processes > that did not exist

Re: checkpointer and other server processes crashing

2021-02-15 Thread Adrian Klaver
On 2/15/21 1:50 PM, Joe Abbate wrote: 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 loo

Re: checkpointer and other server processes crashing

2021-02-15 Thread Joe Abbate
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 (PI

Re: checkpointer and other server processes crashing

2021-02-15 Thread Tim Cross
Joe Abbate writes: > Hello, > > 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: Ki

Re: checkpointer and other server processes crashing

2021-02-15 Thread Adrian Klaver
On 2/15/21 1:15 PM, Joe Abbate wrote: Hello, 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 sign

checkpointer and other server processes crashing

2021-02-15 Thread Joe Abbate
Hello, 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 othe