Re: OpenBSD versus semaphores

Поиск
Список
Период
Сортировка
Искать
От
Mikael Kjellström
Тема
Re: OpenBSD versus semaphores
Дата
Msg-id
f5e58ccb-4433-4a30-ce8d-ec87a784be7a@mksoft.nu
Ответ на
Список
Дерево обсуждения
OpenBSD versus semaphores Tom Lane <tgl@sss.pgh.pa.us>
Re: OpenBSD versus semaphores Thomas Munro <thomas.munro@enterprisedb.com>
Re: OpenBSD versus semaphores Tom Lane <tgl@sss.pgh.pa.us>
Re: OpenBSD versus semaphores Thomas Munro <thomas.munro@gmail.com>
Re: OpenBSD versus semaphores Abel Abraham Camarillo Ojeda <acamari@verlet.org>
Re: OpenBSD versus semaphores Mikael Kjellström <mikael.kjellstrom@mksoft.nu>
Re: OpenBSD versus semaphores Tom Lane <tgl@sss.pgh.pa.us>

On 2019-01-08 07:14, Tom Lane wrote:
> I've been toying with OpenBSD lately, and soon noticed a seriously
> annoying problem for running Postgres on it: by default, its limits
> for SysV semaphores are only SEMMNS=60, SEMMNI=10.  Not only does that
> greatly constrain the number of connections for a single installation,
> it means that our TAP tests fail because you can't start two postmasters
> concurrently (cf [1]).
> 
> Raising the annoyance factor considerably, AFAICT the only way to
> increase these settings is to build your own custom kernel.

You don't need to build your custom kernel to change those settings.

Just add:

kern.seminfo.semmni=20

to /etc/sysctl.conf and reboot

/Mikael

В списке pgsql-hackers по дате отправления
От: Kyotaro HORIGUCHI
Дата:
От: Abel Abraham Camarillo Ojeda
Дата:
Сообщение: Re: OpenBSD versus semaphores
FAQ