Sean Chittenden <sean@chittenden.org> writes:
> I wonder how correct the following is:
> SHMMAXPGS = ((max_connections * shared_buffers * 16K) + (wal_buffers *
> 8K) + (max_fsm_relations * 40B) + (max_fsm_pages * 6B)) /
> page_size
Not very. shared_buffers are 8K apiece, not 16K, and you don't multiply
them by max_connections. There *is* a multiplier for max_connections
but I'm not sure what it is --- less than 1K, probably. Also you should
allow for the lock table, which will be some small multiplier times
max_connections * max_locks_per_transaction.
> SEMMNI = 2 * max_connections (????)
> SEMMSL = SEMMNI
> SHMSEG = 10 # (???? this is a per SysV process setting)
> SEMMNS = 1.5 * max_connections (????)
> SEMMNU = 0.75 * max_connections (????)
> SEMUME = 10 (????)
Dunno where you got these semaphore numbers from, either.
regards, tom lane