Postgres Pro
Downloads
Home   >   mailing lists

Re: Out of Memory - Mailing list pgsql-general

From greigwise
Subject Re: Out of Memory
Date
Msg-id 1537979569920-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Out of Memory  (greigwise <greigwise@comcast.net>)
Responses Re: Out of Memory  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: greigwise
Date:
Subject: Re: Out of Memory
Next
From: pinker
Date:
Subject: Re: Why the sql is not executed in parallel mode