Re: Increasing the number of semaphores on FreeBSD 4.1 (clarification)

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."

In response to

Responses

Browse pgsql-general by date

  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)