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: | Raw Message | Whole Thread | 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 |