Re: Problem with PostgreSQL 18 and semaphores

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

Marc Baudoin <babafou%babafou.eu.org@localhost> écrit :
> 
> which gives values very close to what I've come to empirically:
> 
> kern.ipc.semmni=11
> kern.ipc.semmns=187

I just tried on Linux (Rocky Linux 9.6):

$ sysctl kernel.sem
kernel.sem = 32000	1024000000	500	32000

which is equivalent to:

kern.ipc.semmni=32000	(last value on the line)
kern.ipc.semmns=1024000000

This is way more than the default values on NetBSD.

I think the PostgreSQL development group mostly cares about Linux
these days so they probably didn't notice the default values on
NetBSD are not enough to please PostgreSQL 18.

So I believe those should be raised (for 11.0 and 10.2) because
PostgreSQL should be able to run out of the box on NetBSD.

I'm using:

kern.ipc.semmni=20
kern.ipc.semmns=200

on my systems and this is enough (at least for me).  I don't know
if higher values would be more suited for other uses (Manuel
Bouyer uses higher values).