Re: Calculation of a shared memory - Mailing list pgsql-hackers

From Hiroshi Saito
Subject Re: Calculation of a shared memory
Date
Msg-id 0bc301c81cfe$9ce67900$c601a8c0@HP22720319231
Whole thread Raw
In response to Calculation of a shared memory  ("Hiroshi Saito" <z-saito@guitar.ocn.ne.jp>)
List pgsql-hackers
Hi.

Thanks!

From: "Tom Lane" <tgl@sss.pgh.pa.us>
>> I think it is a permissible range. Thanks!
> 
> Most of the remaining discrepancy is because you did not account for the
> per-shared-buffer management overhead.  The table shows shared_buffers
> as costing 8300 bytes each, not 8192.

Oops, I did the misapprehension by the alteration of MB and kB. 
This estimates the value secured more correctly.

40*(1800+270*64)=    763200 5*(700+270*64)=     89900
28MB*1024/8*8300=  29747200    64kB/8*8200=     65600        1000*70=     70000       179200*6=   1075200
700kB=   716800
 

Total :32527900
ipcs-m:32571392       -43492

Does this suit? 

Regards,
Hiroshi Saito


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Calculation of a shared memory
Next
From: "Gokulakannan Somasundaram"
Date:
Subject: Proposal: Select ... AS OF Savepoint