| From: | Mikael Kjellström <mikael(dot)kjellstrom(at)mksoft(dot)nu> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Cc: | mikael(dot)kjellstrom(at)gmail(dot)com |
| Subject: | Re: OpenBSD versus semaphores |
| Date: | 2019-01-08 07:46:35 |
| Message-ID: | f5e58ccb-4433-4a30-ce8d-ec87a784be7a@mksoft.nu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Abel Abraham Camarillo Ojeda | 2019-01-08 07:47:07 | Re: OpenBSD versus semaphores |
| Previous Message | Kyotaro HORIGUCHI | 2019-01-08 07:43:33 | Re: Improve selectivity estimate for range queries |