Re: psql 9.3 automatic recovery in progress - Mailing list pgsql-general

From Periko Support
Subject Re: psql 9.3 automatic recovery in progress
Date
Msg-id CAK2yrTYn1Fu_M_urJRk+ehQVXUCDM5Epty2d_CBdNogcSrYfHQ@mail.gmail.com
Whole thread Raw
In response to Re: psql 9.3 automatic recovery in progress  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: psql 9.3 automatic recovery in progress
Re: psql 9.3 automatic recovery in progress
List pgsql-general
My current server has 82GB memory.

Default settings but the only parameter I had chance is shared_buffers
from 128MB to 6G.

This server is dedicated to postgresql+odoo.

Is the only parameter I can thing can reduce my memory utilization?

Thanks Tom.


On Mon, Oct 10, 2016 at 10:03 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Periko Support <pheriko.support@gmail.com> writes:
>> I got some issues with my DB under ubuntu 14.x.
>> PSQL 9.3, odoo 7.x.
>
>> 2016-09-12 09:00:01 PDT LOG:  server process (PID 23958) was
>> terminated by signal 9: Killed
>
> Usually, SIGKILLs coming out of nowhere indicate that the Linux OOM killer
> has decided to target some database process.  You need to do something to
> reduce memory pressure and/or disable memory overcommit so that that
> doesn't happen.
>
>                         regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql 9.3 automatic recovery in progress
Next
From: Periko Support
Date:
Subject: Re: psql 9.3 automatic recovery in progress