From: | Vivek Khera <khera(at)kcilink(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgres 7.1.1 on Freebsd 4.3? |
Date: | 2001-11-06 18:02:13 |
Message-ID: | x7vggnlqvu.fsf@onceler.kciLink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>>>> "RA" == Rudy Amid <radix33(at)hotmail(dot)com> writes:
RA> The Postgres FAQ states that my kernel may not have enough (~10Mb)
RA> of shared memory, but to my dismay, I also can't figure out how to
RA> tweak that on the freebsd kernel config.
No need for a new kernel. Just use sysctl to set the value at runtime,
like this, in your /etc/sysctl.conf file (create it if you don't have
one already)
# tuning for PostgreSQL
kern.ipc.shmall=65535
kern.ipc.shmmax=268435456
kern.ipc.shm_use_phys=1
You can run the above with, eg, "sysctl -w kern.ipc.shmall=65535" at
the command line as well, at any time.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2001-11-06 18:12:27 | Re: Probably simple answer |
Previous Message | Jeff Eckermann | 2001-11-06 17:46:53 | Re: postgres 7.1.1 on Freebsd 4.3? |