| From: | Radovan Jablonovsky <radovan(dot)jablonovsky(at)replicon(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: terminating autovacuum process due to administrator command |
| Date: | 2012-06-28 01:24:24 |
| Message-ID: | CAJYcdTvzoftfYKLHziRGXWqMTVevSDsMQypsjbEybBt3rzEebA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
SEMMNIMaximum 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2012-06-28 08:05:26 | Re: terminating autovacuum process due to administrator command |
| Previous Message | Simon Riggs | 2012-06-27 17:58:41 | Re: [ADMIN] pg_basebackup blocking all queries with horrible performance |