Hi.
Thanks!
From: "Tom Lane" <[EMAIL PROTECTED]>
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 m
"Hiroshi Saito" <[EMAIL PROTECTED]> writes:
> 40*(1800+270*64)= 763200
> 5*(700+270*64)= 89900
> 28MB=29360128
> 64kB= 65536
> 1000*70= 7
> 179200*6= 1075200
>700kB= 716800
> Total :32140764
> ipcs-m:32571392
>-430628
> I
Hi.
From: "Tom Lane" <[EMAIL PROTECTED]>
"Hiroshi Saito" <[EMAIL PROTECTED]> writes:
inet% ipcs -b -m
Shared Memory:
T ID KEY MODEOWNERGROUP SEGSZ
m 917504 5432001 --rw---saitowheel 32571392
40*(400+270*64)= 707200
5*(60
"Hiroshi Saito" <[EMAIL PROTECTED]> writes:
> inet% ipcs -b -m
> Shared Memory:
> T ID KEY MODEOWNERGROUP SEGSZ
> m 917504 5432001 --rw---saitowheel 32571392
> 40*(400+270*64)= 707200
> 5*(600+270*64)= 89400
>28MB=
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%
