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 CAK2yrTauGdbVDwPwFwig628DT28kDi=YtLx+bbf8PUhOjfDMKA@mail.gmail.com
Whole thread Raw
In response to Re: psql 9.3 automatic recovery in progress  (Periko Support <pheriko.support@gmail.com>)
List pgsql-general
Or add more memory to my server?

On Mon, Oct 10, 2016 at 11:05 AM, Periko Support
<pheriko.support@gmail.com> wrote:
> 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: Periko Support
Date:
Subject: Re: psql 9.3 automatic recovery in progress
Next
From: Pavel Stehule
Date:
Subject: Re: HA Cluster Solution?