overcommit_memory ?

I am trying to tune the postgresql

Reading the

http://www.postgresql.org/docs/current/ … urces.html">http://www.postgresql.org/docs/current/static/kernel-resources.html

I see I should set various parameters

I tried the overcommit_memory=2 but my vbox ubutnu 11.10 freezes when I did it.

I have linode ubutnu 11.10 1GB

Are you using this system setting?

Thanks

Nenad

2 Replies

for example here http://od-eon.com/blogs/stefan/killing-oom-killer/

it is suggested for not letting postgresql die set

vm.overcommit_ratio = 100

vm.overcommit_memory = 2

When I have increase the memory of my vbox ubuntu guest I managed to login and to revert the overcommit back.

I suppose the graphical part of ubuntu is too heavy for 1GB with this setting=2.

I think I will take a snapshot of linode and try the above settings

Or maybe I am wrong?

I have found this on http://feross.org/how-to-setup-your-linode/

"

Reboot server on out-of-memory condition

Still, in cases where something goes awry, it is good to automatically reboot your server when it runs out of memory. This will cause a minute or two of downtime, but it’s better than languishing in the swapping state for potentially hours or days.

You can leverage a couple kernel settings and Lassie to make this happen on Linode.

Adding the following two lines to your /etc/sysctl.conf will cause it to reboot after running out of memory:

vm.paniconoom=1

kernel.panic=10

"

Is this common practice?

Thanks

Nenad

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct