From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
---|---|
To: | Philip Hallstrom <philip(at)adhesivemedia(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Increasing the number of semaphores on FreeBSD 4.1 (clarification) |
Date: | 2000-11-10 04:55:32 |
Message-ID: | 20001109205532.T11449@fw.wintelcom.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
* Philip Hallstrom <philip(at)adhesivemedia(dot)com> [001109 20:37] wrote:
>
> > * Philip Hallstrom <philip(at)adhesivemedia(dot)com> [001109 19:12] wrote:
> > > Hi -
> > > I recently tried to start postmaster (7.0.2) with -B 128 -N 64 and
> > > got the "semget failed" error. Looking in the faq[1] it says I need to
> > > increase the amount allowed in the kernel. It tells me what I need to do,
> > > but my question is what values should I set them to? Is there any way to
> > > figure it out based on load, etc? Also, are there detrimental effects to
> > > setting them too high?
> >
> > What OS are you using?
>
> FreeBSD 4.1
>
> > > [1]http://postgresql.readysetnet.com/docs/faq-bsdi
> >
> > If it's FreeBSD we've documented the tunables here:
> > http://www.freebsd.org/cgi/cvsweb.cgi/src/sys/i386/conf/NOTES?rev=1.857
> >
> > The docs will probably also help if you're using BSD/os.
> >
> > Also you don't want to "go nuts" with raising these values, they
> > can cause the kernel to allocate too much memory for these structures
> > and cause problems booting or running your system.
>
> Yeah, that's what I've seen... I guess I was wondering if there were any
> guidelines to raising them.. I mean should I up the defaults by 10? Or
> up them by a percentage (to keep the relationship), etc...
here's what I use:
options SHMMAXPGS=512000
options SHMSEG=128
options SEMMNI=40 # /* # of semaphore identifiers */
options SEMMNS=240 # /* # of semaphores in system */
options SEMUME=40 # /* max # of undo entries per process */
options SEMMNU=120 # /* # of undo structures in system */
I have a gig of RAM though.
--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Hallstrom | 2000-11-10 05:01:37 | How to get postmaster to read it's new log file? |
Previous Message | Philip Hallstrom | 2000-11-10 04:32:19 | Re: Increasing the number of semaphores on FreeBSD 4.1 (clarification) |