Or add more memory to my server? On Mon, Oct 10, 2016 at 11:05 AM, Periko Support <pheriko.support@xxxxxxxxx> 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@xxxxxxxxxxxxx> wrote: >> Periko Support <pheriko.support@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general