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

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org,Vikas Sharma <shavikas(at)gmail(dot)com>
Subject: Re: Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child
Date: 2019-02-13 17:38:15
Message-ID: CF692086-0B22-4DB3-B14C-47890E2D20A5@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12 February 2019 17:20:09 CET, Vikas Sharma <shavikas(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2019-02-13 18:09:51 Re: Subquery to select max(date) value
Previous Message Michael Lewis 2019-02-13 17:37:53 Re: Postgresql RDS DB Latency Chossing Hash join Plan