Re: Calculation of a shared memory

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Calculation of a shared memory
Дата
Msg-id 9045.1193939293@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Calculation of a shared memory  ("Hiroshi Saito" <z-saito@guitar.ocn.ne.jp>)
Список pgsql-hackers
"Hiroshi Saito" <z-saito@guitar.ocn.ne.jp> writes:
> 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?)

Hmm, those numbers never got updated for 8.2.  The per-backend
multiplier is particularly off, since it's not accounting for
the in-memory pg_stat_activity array (PgBackendStatus is 1208
bytes on my machine...)  Also, you neglected to add the fixed space,
which was claimed to be 500K as of 8.1, but seems to have bloated
to about 700K in 8.2 and 770K in HEAD.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: beta2, I can't set UTF-8 for czech locales on win
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgresql 8.3 beta crash