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
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 |