Thread: [Fwd: Re: [DOCS] Instructions for FreeBSD ipc config showing age]

[Fwd: Re: [DOCS] Instructions for FreeBSD ipc config showing age]

From
Mark Kirkwood
Date:
As discussed on -docs.
(Not really sure if I need to explicitly forward here....)

regards

Mark

Tom Lane wrote:
>
>
> This seems a bit awkwardly phrased:
>
>
>>+       <para>
>>+        Versions before 4.0 will require a kernel rebuild, see the
>>+        <systemitem class="osname">NetBSD</> and <systemitem
>>+        class="osname">OpenBSD</> instructions above, however the key word is
>>+        <literal>options</literal> (plural) in this case.
>>        </para>
>
>
> Perhaps
>
>     FreeBSD versions before 4.0 work like NetBSD and OpenBSD (see above),
>     except that the configuration file uses the key word "options"
>     instead of "option".
>
Yeah - much nicer.
> Also, alphabetization would suggest putting the FreeBSD entry before the
> other two, not after, so maybe that should be "see below".
Thanks - had not considered that!

Amended patch attached.

regards

Mark

--- runtime.sgml.orig    Sat Jan 29 18:30:50 2005
+++ runtime.sgml    Tue Feb  1 14:25:53 2005
@@ -4351,9 +4351,51 @@

      <varlistentry>
       <term><systemitem class="osname">FreeBSD</></term>
+      <indexterm><primary>FreeBSD</><secondary>IPC configuration</></>
+      <listitem>
+       <para>
+        The default settings are only suitable for small installations
+        (default <varname>SHMMAX</varname> is 32 MB). Changes can be made via
+        the <command>sysctl</command> or <command>loader</command> interfaces.
+        Firstly the ones that are settable using <command>sysctl</command>:
+<screen>
+<prompt>$</prompt> <userinput>systcl -w kern.ipc.shmall=32768</userinput>
+<prompt>$</prompt> <userinput>systcl -w kern.ipc.shmmax=134217728</userinput>
+<prompt>$</prompt> <userinput>systcl -w kern.ipc.semmap=256</userinput>
+</screen>
+        These to be saved between reboots in <filename>/etc/sysctl.conf.
+       </para>
+       <para>
+        The remaining sempahore 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>
+        You might also want to configure your kernel to lock shared
+        memory into RAM and prevent it from being paged out to swap.
+        Use the <command>sysctl</> setting
+        <literal>kern.ipc.shm_use_phys</>.
+       </para>
+       <para>
+        <systemitem class="osname">FreeBSD</> versions before 4.0 work like
+        <systemitem class="osname">NetBSD</> and <systemitem class="osname">
+        OpenBSD</> (see below), except that the configuration file uses the
+        key word "options" instead of "option".
+       </para>
+      </listitem>
+     </varlistentry>
+
+
+     <varlistentry>
       <term><systemitem class="osname">NetBSD</></term>
       <term><systemitem class="osname">OpenBSD</></term>
-      <indexterm><primary>FreeBSD</><secondary>IPC configuration</></>
       <indexterm><primary>NetBSD</><secondary>IPC configuration</></>
       <indexterm><primary>OpenBSD</><secondary>IPC configuration</></>
       <listitem>
@@ -4364,19 +4406,16 @@
         the option <varname>SHMMAXPGS</> (in pages). The following
         shows an example of how to set the various parameters:
 <programlisting>
-options         SYSVSHM
-options         SHMMAXPGS=4096
-options         SHMSEG=256
+option         SYSVSHM
+option         SHMMAXPGS=4096
+option         SHMSEG=256

-options         SYSVSEM
-options         SEMMNI=256
-options         SEMMNS=512
-options         SEMMNU=256
-options         SEMMAP=256
+option         SYSVSEM
+option         SEMMNI=256
+option         SEMMNS=512
+option         SEMMNU=256
+option         SEMMAP=256
 </programlisting>
-        (On <systemitem class="osname">NetBSD</> and <systemitem
-        class="osname">OpenBSD</> the key word is actually
-        <literal>option</literal> singular.)
        </para>
        <para>
         You might also want to configure your kernel to lock shared


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Re: [Fwd: Re: [DOCS] Instructions for FreeBSD ipc config

From
Neil Conway
Date:
Applied, thanks.

On Wed, 2005-02-02 at 17:33 +1300, Mark Kirkwood wrote:
> As discussed on -docs.
> (Not really sure if I need to explicitly forward here....)

Yeah, forwarding (or CC'ing) to -patches is helpful.

-Neil



Re: [Fwd: Re: [DOCS] Instructions for FreeBSD ipc config showing

From
Bruce Momjian
Date:
Applied by Neil. Thanks.

---------------------------------------------------------------------------

Mark Kirkwood wrote:
> As discussed on -docs.
> (Not really sure if I need to explicitly forward here....)
>
> regards
>
> Mark
>

-- Start of included mail From: Mark Kirkwood <markir@coretech.co.nz>

> Date: Tue, 01 Feb 2005 14:29:39 +1300
> To: Tom Lane <tgl@sss.pgh.pa.us>
> cc: pgsql-docs@postgresql.org
> Subject: Re: [DOCS] Instructions for FreeBSD ipc config showing age

> Tom Lane wrote:
> >
> >
> > This seems a bit awkwardly phrased:
> >
> >
> >>+       <para>
> >>+        Versions before 4.0 will require a kernel rebuild, see the
> >>+        <systemitem class="osname">NetBSD</> and <systemitem
> >>+        class="osname">OpenBSD</> instructions above, however the key word is
> >>+        <literal>options</literal> (plural) in this case.
> >>        </para>
> >
> >
> > Perhaps
> >
> >     FreeBSD versions before 4.0 work like NetBSD and OpenBSD (see above),
> >     except that the configuration file uses the key word "options"
> >     instead of "option".
> >
> Yeah - much nicer.
> > Also, alphabetization would suggest putting the FreeBSD entry before the
> > other two, not after, so maybe that should be "see below".
> Thanks - had not considered that!
>
> Amended patch attached.
>
> regards
>
> Mark
>

> --- runtime.sgml.orig    Sat Jan 29 18:30:50 2005
> +++ runtime.sgml    Tue Feb  1 14:25:53 2005
> @@ -4351,9 +4351,51 @@
>
>       <varlistentry>
>        <term><systemitem class="osname">FreeBSD</></term>
> +      <indexterm><primary>FreeBSD</><secondary>IPC configuration</></>
> +      <listitem>
> +       <para>
> +        The default settings are only suitable for small installations
> +        (default <varname>SHMMAX</varname> is 32 MB). Changes can be made via
> +        the <command>sysctl</command> or <command>loader</command> interfaces.
> +        Firstly the ones that are settable using <command>sysctl</command>:
> +<screen>
> +<prompt>$</prompt> <userinput>systcl -w kern.ipc.shmall=32768</userinput>
> +<prompt>$</prompt> <userinput>systcl -w kern.ipc.shmmax=134217728</userinput>
> +<prompt>$</prompt> <userinput>systcl -w kern.ipc.semmap=256</userinput>
> +</screen>
> +        These to be saved between reboots in <filename>/etc/sysctl.conf.
> +       </para>
> +       <para>
> +        The remaining sempahore 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>
> +        You might also want to configure your kernel to lock shared
> +        memory into RAM and prevent it from being paged out to swap.
> +        Use the <command>sysctl</> setting
> +        <literal>kern.ipc.shm_use_phys</>.
> +       </para>
> +       <para>
> +        <systemitem class="osname">FreeBSD</> versions before 4.0 work like
> +        <systemitem class="osname">NetBSD</> and <systemitem class="osname">
> +        OpenBSD</> (see below), except that the configuration file uses the
> +        key word "options" instead of "option".
> +       </para>
> +      </listitem>
> +     </varlistentry>
> +
> +
> +     <varlistentry>
>        <term><systemitem class="osname">NetBSD</></term>
>        <term><systemitem class="osname">OpenBSD</></term>
> -      <indexterm><primary>FreeBSD</><secondary>IPC configuration</></>
>        <indexterm><primary>NetBSD</><secondary>IPC configuration</></>
>        <indexterm><primary>OpenBSD</><secondary>IPC configuration</></>
>        <listitem>
> @@ -4364,19 +4406,16 @@
>          the option <varname>SHMMAXPGS</> (in pages). The following
>          shows an example of how to set the various parameters:
>  <programlisting>
> -options         SYSVSHM
> -options         SHMMAXPGS=4096
> -options         SHMSEG=256
> +option         SYSVSHM
> +option         SHMMAXPGS=4096
> +option         SHMSEG=256
>
> -options         SYSVSEM
> -options         SEMMNI=256
> -options         SEMMNS=512
> -options         SEMMNU=256
> -options         SEMMAP=256
> +option         SYSVSEM
> +option         SEMMNI=256
> +option         SEMMNS=512
> +option         SEMMNU=256
> +option         SEMMAP=256
>  </programlisting>
> -        (On <systemitem class="osname">NetBSD</> and <systemitem
> -        class="osname">OpenBSD</> the key word is actually
> -        <literal>option</literal> singular.)
>         </para>
>         <para>
>          You might also want to configure your kernel to lock shared
>

>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
-- End of included mail.

>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073