| From: | "MauMau" <maumau307(at)gmail(dot)com> | 
|---|---|
| To: | "Joshua Berkus" <josh(at)agliodbs(dot)com>, <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | Is this a correct recommendation for Solaris 10 kernel settings? | 
| Date: | 2013-09-09 12:29:44 | 
| Message-ID: | 0535F276FB924BE69E10D0B5209C1295@maumau | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2013-09-09 12:29:58 | Re: [bug fix] strerror() returns ??? in a UTF-8/C database with LC_MESSAGES=non-ASCII | 
| Previous Message | Heikki Linnakangas | 2013-09-09 11:58:43 | Re: Strange hanging bug in a simple milter |