Re: Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child

2019-02-13 Thread Andreas Kretschmer
On 12 February 2019 17:20:09 CET, Vikas Sharma wrote: >Hello All, > >I have a 4 node PostgreSQL 9.6 cluster with streaming replication. we >encounter today the Out of Memory Error on the Master which resulted >in >All postres processes restarted and cluster recovered itself. Please >let >me kno

Re: Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child

2019-02-13 Thread Vikas Sharma
Thank you Adrian for the reply, I did check the postgres processes running around the time when OOM was invoked, there were lots of high CPU consuming postgres processes running long running selects. I am not sure of how to interpret the memory terms appearing in linux dmeg or /var/log/messages b

Re: Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child

2019-02-12 Thread Adrian Klaver
On 2/12/19 8:20 AM, Vikas Sharma wrote: Hello All, I have a 4 node PostgreSQL 9.6 cluster with streaming replication.  we encounter today the Out of Memory  Error on the Master which resulted in All postres  processes restarted and cluster recovered itself. Please let me know the best way to

Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child

2019-02-12 Thread Vikas Sharma
Hello All, I have a 4 node PostgreSQL 9.6 cluster with streaming replication. we encounter today the Out of Memory Error on the Master which resulted in All postres processes restarted and cluster recovered itself. Please let me know the best way to diagnose this issue. The error seen in the