Re: Shared memory usage in PostgreSQL 9.1

Am 03.12.2011 20:31, schrieb Christoph Zwerschke:
> Then, the corrected sum is 449627320 Bytes, which is only about 2MB less
> than was requested. This remaining discrepancy can probably be explained
> by additional overhead for a PostgreSQL 9.1 64bit server vs. a
> PostgreSQL 8.3 32bit server for which the table was valid.

And this additional overhead obviously is created per max_connections,
not per shared_buffers. While the docs suggest there should be 19kB per
connection, we measured about 45kB per connection. This explains the
about 2MB difference when max_connections is 100.

-- Christoph