Re: terminating autovacuum process due to administrator command
От | Albe Laurenz |
---|---|
Тема | Re: terminating autovacuum process due to administrator command |
Дата | |
Msg-id | D960CB61B694CF459DCFB4B0128514C20812788F@exadv11.host.magwien.gv.at обсуждение исходный текст |
Ответ на | Re: terminating autovacuum process due to administrator command (Radovan Jablonovsky <radovan.jablonovsky@replicon.com>) |
Список | pgsql-admin |
Radovan Jablonovsky wrote: > 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? I don't know what a "logical partition" in Linux or PostgreSQL should be (they can hardly be talking about disk partitions), so it does not make sense to me. Yours, Laurenz Albe
В списке pgsql-admin по дате отправления: