Could you, please navigate me how to explain 2 different calculation kernel parameter SEMMNI.
In PostgreSQL documentation: http://www.postgresql.org/docs/9.1/static/kernel-resources.html#SYSVIPC is used this calculation of SEMMNI.
| SEMMNI | Maximum number of semaphore identifiers (i.e., sets) | at least ceil((max_connections + autovacuum_max_workers + 4) / 16) |
In this document http://deepakmurthy.wordpress.com/2012/01/04/configure-a-box-for-kernel-and-postgres-configuration/ is used different calculation of SEMMNI.
SEMMNI = ((2 * max connections) * logical partitions on the server + number of local applications (max app server connections) )
Does it make sense? And if yes why?
Sincerely,
Radovan Jablonovsky DBA
