| 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: | Whole Thread | Raw Message | 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 |