Skip site navigation (1) Skip section navigation (2)

Re: 8.1beta, SunOS and shmget

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.1beta, SunOS and shmget
Date: 2005-08-29 13:37:27
Message-ID: dev32l$29p8$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers
""Sergey E. Koposov"" <math(at)sai(dot)msu(dot)ru> wrote
>
> selecting default max_connections ... 10
> selecting default shared_buffers ... 50
> DETAIL:  Failed system call was shmget(key=1, size=1957888, 03600).
>
> selecting default max_connections ... 10
> selecting default shared_buffers ... 20
> DETAIL:  Failed system call was shmget(key=1, size=1712128, 03600).
>
> selecting default max_connections ... 5
> selecting default shared_buffers ... 16
> DETAIL:  Failed system call was shmget(key=1, size=1613824, 03600).
>
> To me it seems quite strange, since that behaviour does not relate with
> the formulae "250 kB + 8.2 kB * shared_buffers + 14.2 kB * max_connections
> up to infinity" from documentation.
>

If the linear relationship is still held, the shm formula induced from your 
test is:

    1384 kB + 8 kB * shared_buffers + 12.8 kB * max_connections

Seems in 8.1, the base shm requirement is increased. But I am not where they 
are from.

Regards,
Qingqing






In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-08-29 13:58:19
Subject: Re: SSL client crt verification
Previous:From: David FetterDate: 2005-08-29 13:29:42
Subject: Re: [HACKERS] Improved \df(+) in psql + backward-compatibility

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group