docs/9.1/static/kernel-resources.html needs updating for NetBSD

Started by Emmanuel Kasperabout 13 years ago2 messagesdocs
Jump to latest
#1Emmanuel Kasper
emmanuel@libera.cc

Hello

The default number of semaphores sets of NetBSD ist too low for Postgres
(tested on 9.1)

I would suggest replacing the sentence:

In NetBSD 5.0 and later, IPC parameters can be adjusted using sysctl,
for example:

$ sysctl -w kern.ipc.shmmax=16777216

with the following:

The default settings are only suitable for small installations. In
NetBSD 5.0 and later, IPC parameters should be adjusted using sysctl,
for example:

$ sysctl -w kern.ipc.shmmax=16777216
$ sysctl -w kern.ipc.semmni=256
$ sysctl -w kern.ipc.semmns=512

Tuning NetBSD for Postgres is mentionned at
http://wiki.netbsd.org/tutorials/tuning_netbsd_for_performance/

Emmanuel

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Emmanuel Kasper (#1)
Re: docs/9.1/static/kernel-resources.html needs updating for NetBSD

On Wed, 2013-02-20 at 17:42 +0100, Emmanuel Kasper wrote:

Hello

The default number of semaphores sets of NetBSD ist too low for Postgres
(tested on 9.1)

I would suggest replacing the sentence:

In NetBSD 5.0 and later, IPC parameters can be adjusted using sysctl,
for example:

$ sysctl -w kern.ipc.shmmax=16777216

with the following:

The default settings are only suitable for small installations. In
NetBSD 5.0 and later, IPC parameters should be adjusted using sysctl,
for example:

$ sysctl -w kern.ipc.shmmax=16777216
$ sysctl -w kern.ipc.semmni=256
$ sysctl -w kern.ipc.semmns=512

In 9.3, the requirements for shared memory have changed, so this might
no longer be appropriate advice going forward.

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs