On Wed, Mar 02, 2005 at 06:35:01PM +0100, Stefan Hans wrote:
> http://developer.postgresql.org/docs/postgres/kernel-resources.html
>
> 16.5.1
>
> "FreeBSD"
>
> ...
>
> $ systcl -w kern.ipc.shmall=32768
> $ systcl -w kern.ipc.shmmax=134217728
> $ systcl -w kern.ipc.semmap=256
>
> "Linux"
> ...
>
> $ systcl -w kernel.shmmax=134217728
> $ systcl -w kernel.shmall=2097152
>
> systcl is wrong sysctl notStefan
Patch attached. Thanks, Stefan :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
? sysctl.diff
Index: doc/src/sgml/runtime.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/runtime.sgml,v
retrieving revision 1.305
diff -c -r1.305 runtime.sgml
*** doc/src/sgml/runtime.sgml 26 Feb 2005 23:19:05 -0000 1.305
--- doc/src/sgml/runtime.sgml 2 Mar 2005 18:27:17 -0000
***************
*** 4360,4368 ****
<command>loader</command> interfaces. The following
parameters can be set 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>
To have these settings persist over reboots, modify
<filename>/etc/sysctl.conf</filename>.
--- 4360,4368 ----
<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>.
***************
*** 4466,4473 ****
and explicitly set the maximum total shared memory size to 2097152
pages (the default):
<screen>
! <prompt>$</prompt> <userinput>systcl -w kernel.shmmax=134217728</userinput>
! <prompt>$</prompt> <userinput>systcl -w kernel.shmall=2097152</userinput>
</screen>
In addition these settings can be saved between reboots in
<filename>/etc/sysctl.conf.
--- 4466,4473 ----
and explicitly set the maximum total shared memory size to 2097152
pages (the default):
<screen>
! <prompt>$</prompt> <userinput>sysctl -w kernel.shmmax=134217728</userinput>
! <prompt>$</prompt> <userinput>sysctl -w kernel.shmall=2097152</userinput>
</screen>
In addition these settings can be saved between reboots in
<filename>/etc/sysctl.conf.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
