Re: postgres bogged down beyond tolerance

"Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)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!