number of semaphores and semaphore sets

From: Anton Yuzhaninov <citrin(at)citrin(dot)ru>
To: pgsql-docs(at)postgreSQL(dot)org
Subject: number of semaphores and semaphore sets
Date: 2011-03-21 16:05:12
Message-ID: 4D877738.7000609@citrin.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

This page:
http://www.postgresql.org/docs/9.0/interactive/kernel-resources.html

has formula:
ceil((max_connections + autovacuum_max_workers) / 16)

for number of semaphore sets (identifiers).

It seems to be wrong (outdated).

Correct formula seems to be

ceil((max_connections + autovacuum_max_workers + 4) / 16)

Semaphore sets created in src/backend/storage/lmgr/proc.c:
1. MaxConnections
2. autovacuum_max_workers + 1
3. NUM_AUXILIARY_PROCS (currently 3)

--
Anton Yuzhaninov

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Leslie S Satenstein 2011-03-21 19:16:03 Re: 9.1 release notes corrections
Previous Message Josh Berkus 2011-03-20 20:32:49 Add strftime escapes to Log config