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