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
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 |