Postgres Pro
Downloads
Home   >   mailing lists

Re: terminating autovacuum process due to administrator command - Mailing list pgsql-admin

From Radovan Jablonovsky
Subject Re: terminating autovacuum process due to administrator command
Date
Msg-id CAJYcdTvzoftfYKLHziRGXWqMTVevSDsMQypsjbEybBt3rzEebA@mail.gmail.com
Whole thread Raw
In response to terminating autovacuum process due to administrator command  (Radovan Jablonovsky <radovan.jablonovsky@replicon.com>)
Responses Re: terminating autovacuum process due to administrator command  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view
Hello,

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)

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

pgsql-admin by date:

Previous
From: 김준철
Date:
Subject: Re: a very slow SQL
Next
From: "Albe Laurenz"
Date:
Subject: Re: terminating autovacuum process due to administrator command