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 <[email protected]> wrote: > Periko Support <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
