Hello, Josh, all,
Could you explain why the following paragraph is necessary? I'm afraid this
is not correct and we need to remove it, because:
1. One PostgreSQL instance only needs one shmid.
2. The calculation of the number of semids is shown before, so we don't say
4096.
3. PostgreSQL does not use IPC message queues. max-msg-ids is the number of
message queue ids, isn't it?
http://www.postgresql.org/docs/current/static/kernel-resources.html#SYSVIPC
[Excerpt]
Other recommended kernel setting changes for database servers which will
have a large number of connections are:
project.max-shm-ids=(priv,32768,deny)
project.max-sem-ids=(priv,4096,deny)
project.max-msg-ids=(priv,4096,deny)
I'm asking you because I found your proposal of the above article here:
http://www.postgresql.org/message-id/4BE9C10A.4040807@agliodbs.com
Regards
MauMau