Postgres Pro
Downloads
Home   >   mailing lists

Re: Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child
Date
Msg-id CF692086-0B22-4DB3-B14C-47890E2D20A5@a-kretschmer.de
Whole thread Raw
In response to Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child  (Vikas Sharma <shavikas@gmail.com>)
List pgsql-general
Tree view 
On 12 February 2019 17:20:09 CET, Vikas Sharma <shavikas@gmail.com> 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 diagnose this issue.
>

typical reason for oom-kill are too high values for work_mem.


Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company

pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Postgresql RDS DB Latency Chossing Hash join Plan
Next
From: Rich Shepard
Date:
Subject: Re: Subquery to select max(date) value