Re: [HACKERS] postmaster failure with 2-23 snapshot - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] postmaster failure with 2-23 snapshot
Date
Msg-id 199902251736.MAA07505@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] postmaster failure with 2-23 snapshot  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Tom Ivar Helbekkmo <tih@nhh.no> writes:
> > Looking more closely into it, the postmaster is trying to allocate 64
> > semaphores in four groups of 16, so I built a new kernel with a higher
> > limit, and it's now OK.
> > This is as it should be, I hope?  It's not a case of something being
> > misconfigured now, using semaphores instead of some other facility?
> 
> Yes, this is an intentional change --- I guess you haven't been reading
> the hackers list very closely.  The postmaster is now set up to grab
> all the semaphores Postgres could need (for the specified number of
> backend processes) immediately at postmaster startup.  Failing then
> for lack of semaphores seems a better idea than failing under load
> when you try to start the N+1'st client, which is what used to happen.
> 
> There has been some discussion of reducing the default number-of-
> backends limit to 32 so that a stock installation is less likely
> to run out of semaphores.

Tom, better lower that limit soon.  People are having trouble with the
snapshots.


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] postmaster failure with 2-23 snapshot
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: [HACKERS] VACUUM ANALYZE problem on linux