Re: Calculation of a shared memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Calculation of a shared memory
Date: 2007-11-02 02:34:17
Message-ID: 19745.1193970857@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Saito 2007-11-02 03:15:25 Re: Calculation of a shared memory
Previous Message Hiroshi Saito 2007-11-02 01:23:39 Re: Calculation of a shared memory