Re: Is this really advisable? (Postgresql and kernel tweaks)

[Kit Halsted <kit@kithalsted.com>]

So here's a question:

Can I put SEMMNI=256 & SEMMNS=2048 in /etc/sysctl.conf, or do I need 
to recompile the kernel on the database server before it goes live?

Also, could I have found this documented somewhere?

Thanks,
-Kit

At 10:50 PM +0100 12/1/02, Marc Balmer wrote:
>On Sun, 2002-12-01 at 22:45, SirStargazer wrote:
>
>>  >From Postgresql 7.3's README.OpenBSD:
>>  <snip>
>>  The default sizes in the GENERIC kernel for SysV semaphores
>>  are not really large enough for a database with more than a
>>  handful of connections. A server running such a database should
>>  have at least the following:
>>
>  > option          SEMMNI=256
>  > option          SEMMNS=2048
>
>You need that, indeed, to run PosgreSQL.
>
>- Marc


-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety."
-Benjamin Franklin

"...qui desiderat pacem, praeparet bellum"
(...if you would have peace, be prepared for war)
-Flavius Vegetius Renatus