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

From Tom Lane
Subject Re: Calculation of a shared memory
Date
Msg-id 19745.1193970857@sss.pgh.pa.us
Whole thread Raw
In response to Re: Calculation of a shared memory  ("Hiroshi Saito" <z-saito@guitar.ocn.ne.jp>)
List pgsql-hackers
"Hiroshi Saito" <z-saito@guitar.ocn.ne.jp> writes:
> 40*(1800+270*64)=  763200
>   5*(700+270*64)=   89900
>             28MB=29360128
>             64kB=   65536
>          1000*70=   70000
>         179200*6= 1075200
>            700kB=  716800

> Total  :32140764
> ipcs-m:32571392
>        -430628

> 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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: Calculation of a shared memory
Next
From: "Hiroshi Saito"
Date:
Subject: Re: Calculation of a shared memory