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 18:23:57
Message-ID: 4EDA693D.1070807@online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 03.12.2011 18:02, schrieb Christoph Zwerschke:
> The difference could be explained by taking credit for the descriptors
> which may not be comprised in the shared_buffers setting, even if the
> shared_buffers value is set in memory units.

Looked a bit more into this - the shared_buffers setting indeed only
determines the memory for he actual shared buffer blocks, even if given
in memory units. It does not include the descriptors and other freelist
related stuff that is also needed to build the shared buffer pool.

When I increased the shared_buffers by 10000, the shared memory usage
increased by 8372.4 Bytes, this is about 2.2% more than 10000 blocks
would use, close to the 2.5% which are documented.

-- Christoph

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Zwerschke 2011-12-03 18:51:04 Re: Shared memory usage in PostgreSQL 9.1
Previous Message c k 2011-12-03 18:14:47 Re: returning results from plsql function to plpythonu function