Re: OpenBSD versus semaphores

2021-04-01 Thread Thomas Munro
On Fri, Apr 2, 2021 at 9:42 AM Tom Lane wrote: > Thomas Munro writes: > > On Tue, Jan 8, 2019 at 7:14 PM Tom Lane wrote: > >> So I looked around for an alternative, and found out that modern > >> OpenBSD releases support named POSIX semaphores (though not unnamed > >> ones, at least not shared u

Re: OpenBSD versus semaphores

2019-01-08 Thread Tom Lane
=?UTF-8?Q?Mikael_Kjellstr=c3=b6m?= writes: > On 2019-01-08 07:14, Tom Lane wrote: >> 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:

Re: OpenBSD versus semaphores

2019-01-07 Thread Abel Abraham Camarillo Ojeda
On Tue, Jan 8, 2019 at 12:14 AM 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 con

Re: OpenBSD versus semaphores

2019-01-07 Thread Mikael Kjellström
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 si

Re: OpenBSD versus semaphores

2019-01-07 Thread Tom Lane
Thomas Munro writes: > On Tue, Jan 8, 2019 at 7:14 PM Tom Lane wrote: >> So I looked around for an alternative, and found out that modern >> OpenBSD releases support named POSIX semaphores (though not unnamed >> ones, at least not shared unnamed ones). What's more, it appears that >> in this imp

Re: OpenBSD versus semaphores

2019-01-07 Thread Thomas Munro
On Tue, Jan 8, 2019 at 7:14 PM 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 conne

OpenBSD versus semaphores

2019-01-07 Thread Tom Lane
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