Re: Out of Memory

From: greigwise <greigwise(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Out of Memory
Date: 2018-09-26 16:32:49
Message-ID: 1537979569920-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

All right.. one more thing here. Any suggestions for how to set overcommit
on a postgres db server with 16 GB of RAM and no swap? I think I want
vm.overcommit_memory = 2, as I understand that prevents the OOM killer from
zapping me. Is 100% the right way to go for overcommit_ratio? Is there a
drawback to this?

Thanks again.
Greig

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pinker 2018-09-26 16:47:27 Re: Why the sql is not executed in parallel mode
Previous Message greigwise 2018-09-26 16:24:28 Re: Out of Memory