Re: Shared memory usage in PostgreSQL 9.1

From: Christoph Zwerschke <cito(at)online(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Shared memory usage in PostgreSQL 9.1
Date: 2011-12-03 21:33:34
Message-ID: 4EDA95AE.7090608@online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Zwerschke 2011-12-03 21:33:36 Re: Shared memory usage in PostgreSQL 9.1
Previous Message Josh Kupershmidt 2011-12-03 20:15:41 Re: How to get Place Names from Lat Lon