On 2/10/04 12:28 PM, Tom Lane wrote:
> Joe Lester <[EMAIL PROTECTED]> writes:
>> Would this be kern.maxfiles?
>
> Sounds like what you want. There's probably no need to reduce
> maxfilesperproc (and thereby constrain every process not only PG
> backends). You can set PG's max_files_per_process instead.
>
>> Is it OK to set these before starting the server? Or should I set them
>> in /etc/rc?
>
> Damifino. Try a manual sysctl -w and see if it takes ... if not, you
> probably have to set it in /etc/rc.
You can set some of this stuff in /etc/sysctl.conf, which is sourced from
/etc/rc if it exists. The file format looks like this:
kern.maxproc=1000
kern.maxprocperuid=512
...
It just passes that stuff to sysctl -w (after skipping comments, etc.) See
the /etc/rc file for details.
Unfortunately, I've found that putting the shared memory settings in
/etc/sysctl.conf does not work. Instead, I put them in /etc/rc directly.
They're actually already there, just above the part that sources
/etc/sysctl.conf. (Look for the phease "System tuning" in a comment.) I
commented those out and put my own settings in their place. That seems to
work for me.
-John
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
