On 01/03/2012 06:15 PM, Brad Davis wrote:
On Tue, Jan 03, 2012 at 05:02:57PM -0500, Andrew Dunstan wrote:
On 01/03/2012 04:49 PM, Brad Davis wrote:
Hi,
I have a patch that improves the documentation for FreeBSD Kernel Tuning:
- Show a # prompt instead of $ to indicate a root shell is needed
- Remove the -w flag to sysctl since it is not needed anymore and just silently
ignored
- Encourage the user to set the read-only sysctls in /boot/loader.conf, instead
of setting them manually in the loader.
I have put these in a github fork of the repo, but I am new to git. So I
apologize if this is incorrect.
https://github.com/so14k/postgres/commit/12c03bdb2967346e7ad9ce0bdd3db8dfcf81507e
Instead of a URL, please just email us the diff as an attachment.
Normally we prefer these in context diff format, although it doesn't
matter so much for such a small patch.
Sorry about that.. it is attached below.
But you didn't :-) You just cut and pasted it. And if you're not going
to send a context diff, it should be a unidiff such as git normally
produces. Since I didn't actually tell you that I've made a context diff
for you, and it's attached. I'll let someone with more FBSD-fu than me
actually comment on it.
cheers
andrew
*** a/doc/src/sgml/runtime.sgml
--- b/doc/src/sgml/runtime.sgml
***************
*** 794,802 **** options "SEMMNS=240"
<command>loader</command> interfaces. The following
parameters can be set using <command>sysctl</command>:
<screen>
! <prompt>$</prompt> <userinput>sysctl -w kern.ipc.shmall=32768</userinput>
! <prompt>$</prompt> <userinput>sysctl -w kern.ipc.shmmax=134217728</userinput>
! <prompt>$</prompt> <userinput>sysctl -w kern.ipc.semmap=256</userinput>
</screen>
To have these settings persist over reboots, modify
<filename>/etc/sysctl.conf</filename>.
--- 794,802 ----
<command>loader</command> interfaces. The following
parameters can be set using <command>sysctl</command>:
<screen>
! <prompt>#</prompt> <userinput>sysctl kern.ipc.shmall=32768</userinput>
! <prompt>#</prompt> <userinput>sysctl kern.ipc.shmmax=134217728</userinput>
! <prompt>#</prompt> <userinput>sysctl kern.ipc.semmap=256</userinput>
</screen>
To have these settings persist over reboots, modify
<filename>/etc/sysctl.conf</filename>.
***************
*** 804,818 **** options "SEMMNS=240"
<para>
The remaining semaphore settings are read-only as far as
! <command>sysctl</command> is concerned, but can be changed
! before boot using the <command>loader</command> prompt:
! <screen>
! <prompt>(loader)</prompt> <userinput>set kern.ipc.semmni=256</userinput>
! <prompt>(loader)</prompt> <userinput>set kern.ipc.semmns=512</userinput>
! <prompt>(loader)</prompt> <userinput>set kern.ipc.semmnu=256</userinput>
! </screen>
! Similarly these can be saved between reboots in
! <filename>/boot/loader.conf</filename>.
</para>
<para>
--- 804,818 ----
<para>
The remaining semaphore settings are read-only as far as
! <command>sysctl</command> is concerned, but can be set in
! <filename>/boot/loader.conf</filename>:
! <programlisting>
! kern.ipc.semmni=256
! kern.ipc.semmns=512
! kern.ipc.semmnu=256
! </programlisting>
! After modifying these values a reboot is required for the new
! settings to take affect.
</para>
<para>
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
