public inbox for [email protected]  
help / color / mirror / Atom feed
docs/9.1/static/kernel-resources.html needs updating for NetBSD
2+ messages / 2 participants
[nested] [flat]

* docs/9.1/static/kernel-resources.html needs updating for NetBSD
@ 2013-02-20 16:42  Emmanuel Kasper <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Emmanuel Kasper @ 2013-02-20 16:42 UTC (permalink / raw)
  To: pgsql-docs

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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: docs/9.1/static/kernel-resources.html needs updating for NetBSD
@ 2013-02-24 23:55  Peter Eisentraut <[email protected]>
  parent: Emmanuel Kasper <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2013-02-24 23:55 UTC (permalink / raw)
  To: Emmanuel Kasper <[email protected]>; +Cc: pgsql-docs

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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2013-02-24 23:55 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-02-20 16:42 docs/9.1/static/kernel-resources.html needs updating for NetBSD Emmanuel Kasper <[email protected]>
2013-02-24 23:55 ` Peter Eisentraut <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox