2011/11/19 Andrus <kobruleht2@xxxxxx>: >> From here(look familiar): >> http://wiki.postgresql.org/wiki/Performance_Optimization >> http://linuxfinances.info/info/quickstart.html >> http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm > > Thank you. > I tried > > # sysctl -w kernel.shmmax=419430400 > kernel.shmmax = 419430400 > # sysctl -n kernel.shmmax > 419430400 > > according to > http://www.postgresql.org/docs/current/static/kernel-resources.html > this value should be written to /etc/sysctl.conf > > I opened /etc/sysctl.conf but it does not contain this value. > > How to make this setting persistent ? Just add them to the bottom then run sudo sysctl -p to make them take effect. btw, the standard way to control rc stuff is update-rc.d Odd name but it's pretty easy, just look up the man page. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general