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

From Albe Laurenz
Subject Re: terminating autovacuum process due to administrator command
Date
Msg-id D960CB61B694CF459DCFB4B0128514C20812788F@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: terminating autovacuum process due to administrator command  (Radovan Jablonovsky <radovan.jablonovsky@replicon.com>)
List 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 by date:

Previous
From: Radovan Jablonovsky
Date:
Subject: Re: terminating autovacuum process due to administrator command
Next
From: Christian Rosnes
Date:
Subject: Oldest xmin is far in the past