I am trying to tune the postgresql
Reading the
http://www.postgresql.org/docs/current/ ... urces.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

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.panic_on_oom=1
kernel.panic=10
"

Is this common practice?
Thanks
Nenad