diff options
| author | Bruce Momjian | 2000-06-09 16:35:24 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2000-06-09 16:35:24 +0000 |
| commit | bd29cb0ee740459d2a389186c1c5cb37d3eb5ad4 (patch) | |
| tree | 9f02380906ae98c4904eb24b7ce7f4c68a429151 /doc/FAQ_BSDI | |
| parent | 3fe3acb844995e44ac0eba9d06dc70061e769145 (diff) | |
Update bsdi faq.
Diffstat (limited to 'doc/FAQ_BSDI')
| -rw-r--r-- | doc/FAQ_BSDI | 32 |
1 files changed, 22 insertions, 10 deletions
diff --git a/doc/FAQ_BSDI b/doc/FAQ_BSDI index ff00bc321b8..6101c0a26ac 100644 --- a/doc/FAQ_BSDI +++ b/doc/FAQ_BSDI @@ -1,27 +1,39 @@ -This outlines how to increase the number of shared memory buffers -supported by BSD/OS. By default, only 4MB of shared memory is supported -by BSDI. +This outlines modifications to BSD/OS for running PostgreSQL: -Keep in mind that shared memory is not pageable. It is locked in RAM. +1) How to increase resource limits +2) How to increase the number of shared memory buffers -Bruce Momjian (pgman@candle.pha.pa.us) +Bruce Momjian (pgman@candle.pha.pa.us) 2000-06-09 --------------------------------------------------------------------------- -Increase SHMMAXPGS by 1024 for every additional 4MB of shared -memory: +1) To increase the amount of malloc'ed memory and files opened by +PostgreSQL, add this: + + :datasize-cur=600M:\ + :openfiles-cur=256: + +to your /etc/login.conf file. + +--------------------------------------------------------------------------- + +2a) By default, only 4MB of shared memory is supported by BSDI. Keep in +mind that shared memory is not pageable. It is locked in RAM. + +To increase the number of buffers supported by the postmaseter, increase +SHMMAXPGS by 1024 for every additional 4MB of shared memory: /sys/sys/shm.h:69:#define SHMMAXPGS 1024 /* max hardware pages... The default setting of 1024 is for a maximum of 4MB of shared memory. For those running 4.1 or later, just recompile the kernel and reboot. -For those running earlier releases, there are more steps outlined below. +For those running earlier releases, see step 2b. --------------------------------------------------------------------------- -Use bpatch to find the sysptsize value for the current kernel. -This is computed dynamically at bootup. +2b) For 4.01 and earlier, use bpatch to find the sysptsize value for +the current kernel. This is computed dynamically at bootup. $ bpatch -r sysptsize 0x9 = 9 |