Calculation of a shared memory

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Calculation of a shared memory
Date: 2007-11-01 14:46:11
Message-ID: 068c01c81c95$f1cce120$c601a8c0@HP22720319231
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi.

I think that a calculation sheet will be made.
However, calculation does not suitable.:-(

It is this.(8.2.5 Default-FreeBSD)
--
max_locks_per_transaction 64
max_connections 40
max_prepared_transactions 5
shared_buffers 28MB
wal_buffers 64kB
max_fsm_relations 1000
max_fsm_pages 179200

inet% ipcs -b -m
Shared Memory:
T ID KEY MODE OWNER GROUP SEGSZ
m 917504 5432001 --rw------- saito wheel 32571392

40*(400+270*64)= 707200
5*(600+270*64)= 89400
28MB= 29360128
64kB= 65536
1000*70= 70000
179200*6= 1075200

Total :31367464
ipcs-m:32571392
-1203928 (difference is large: why?)

Table 16-2. Configuration parameters affecting PostgreSQL's shared memory usage
http://www.postgresql.org/docs/8.2/static/kernel-resources.html#SYSVIPC
It may be the bug of postgres or whether the document is wrong....
or My misapprehension.

Can someone see a near value?

Regards,
Hiroshi Saito

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-01 14:56:53 Re: Postgresql 8.3 beta crash
Previous Message Stephen Frost 2007-11-01 14:41:51 krb_match_realm patch