| 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: | Whole Thread | Raw Message | 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 |