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

Поиск
Список
Период
Сортировка
Искать

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

От:
Emmanuel 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


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

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
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.



FAQ