Re: postgres bogged down beyond tolerance

"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:

> Namely, I shutdown the database, issued two commands:
>   /sbin/sysctl -w kernel.shmmax=134217728
>   /sbin/sysctl -w kernel.shmall=2097152
> and rebooted the computer.
>
> After it came up, I checked the shmmax and it is set
> as 33554432.  Which surprised me.  Since I used -w
> flag, I thought it should've written to /etc/sysctl.conf,
> but there is no such entry at all and the data of this
> file is from 2006.


sysctl changes the values for the running kernel. /etc/sysctl is a file you
edit manually to tell the boot scripts what values to store (using sysctl) so
you don't have to run sysctl every time you reboot.


--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!