Re: postgresql 18 and shm

[Marc Baudoin <babafou%babafou.eu.org@localhost>]

Martin Husemann <martin%duskware.de@localhost> écrit :
> On Wed, Jul 15, 2026 at 11:16:02AM +0200, Marc Baudoin wrote:
> > Have a look at this thread from last year:
> > 
> > https://mail-index.netbsd.org/pkgsrc-users/2025/10/25/msg042112.html
> > 
> > The setting that works for me is:
> > 
> > kern.ipc.semmni=20
> > kern.ipc.semmns=200
> 
> I was confused back then, as I overlooked that I had raised the defaults
> on my PostgesSQL machine already by adding this to /etc/sysctl.conf:
> 
> # The PostgresSQL server may need additional semmaphore resources
> kern.posix.semmax=256
> kern.ipc.semmns=256                        
> kern.ipc.semmni=64
> 
> Not sure how I invented those numbers. The defaults are
> 
> kern.posix.semmax = 128
> kern.ipc.semmns = 60
> kern.ipc.semmni = 10

Both kern.ipc.semmni and kern.ipc.semmns have to be raised from
the default values and the ones I use are the least ones
(rounded) that work for PostgreSQL 18.