From: | Christoph Zwerschke <cito(at)online(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Shared memory usage in PostgreSQL 9.1 |
Date: | 2011-12-03 12:39:34 |
Message-ID: | 4EDA1886.6090105@online.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
For a PostgreSQL 9.1.1 instance,
I have used the following postgresql.conf settings:
max_connections = 100
shared_buffers = 400MB
wal_buffers = 16MB
All the other parameters have been left as default values.
When I startup the instance, I get an error message
saying that the shared memory does not suffice
and 451837952 Bytes would be used.
However, this is not what I expect when calculating
the needs according to the documentation, Table 17-2 at
http://www.postgresql.org/docs/current/static/kernel-resources.html
According to that table the usage would be:
Connections: 1908000 Bytes
Autovac workers: 57240 Bytes
Prepared transactions: 0 Bytes
Shared disk buffers: 400MB
WAL buffers: 16MB
Fixed space: 788480 Bytes
Sum: 435145336
This is about 16MB less than what is really requested.
How can this substantial discrepancy be explained?
For PostgreSQL 9.1, some important item must be missing
in Table 17-2, or some values are wrong.
-- Christoph
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2011-12-03 14:10:32 | Re: Postgresql + corrupted disk = data loss. (Need help for database recover) |
Previous Message | Harald Fuchs | 2011-12-03 09:12:35 | Re: Oddball data distribution giving me planner headaches |