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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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