public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Josh Berkus <[email protected]>
Cc: [email protected]
Subject: Re: Change to kernel-resources
Date: Thu, 3 Feb 2011 12:12:01 -0500 (EST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
Josh, can I get a correct, updated version of this so I can add it to
our documentation?
---------------------------------------------------------------------------
Josh Berkus wrote:
> All,
>
> Our Solaris section is out of date. We should change it to:
>
> ===================
>
> Solaris 2.6 to 2.9 (Solaris 6 to Solaris 9)
>
> The default maximum size of a shared memory segment is too low for
> PostgreSQL. The relevant settings can be changed in /etc/system, for
> example:
>
> set shmsys:shminfo_shmmax=0x2000000
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=256
> set shmsys:shminfo_shmseg=256
>
> set semsys:seminfo_semmap=256
> set semsys:seminfo_semmni=512
> set semsys:seminfo_semmns=512
> set semsys:seminfo_semmsl=32
>
> You need to reboot for the changes to take effect.
>
> See also
> http://sunsite.uakom.sk/sunworldonline/swol-09-1997/swol-09-insidesolaris.html
> for information on shared memory under Solaris.
>
> Solaris 2.10 (Solaris 10) and OpenSolaris
>
> In Solaris 10 and OpenSolaris, the default shared memory and semaphore
> settings are good enough for most PostgreSQL applications. Solaris now
> defaults to a SHMMAX of 1/4 of system RAM. If you need to increase this
> in order to set shared memory settings slightly higher, you should use a
> project setting associated with the "postgres" user. For example, run
> the following as root:
>
> projadd -c "PostgreSQL DB User" -K
> "project.max-shm-memory=(privileged,8GB,deny)" -U postgres -G postgres
> user.postgres
>
> This command adds the user.postgres project and raises the shared memory
> maximum for the "postgres" user to 8GB, and takes effect the next time
> that user logs in. The above assumes that there isn't already a project
> 101, and that postgresql is run by the postgres user in the postgres
> group. No reboot is required.
>
> Other recommended kernel setting changes for database servers which will
> have a large number of connections are:
>
> project.max-shm-ids=(priv,32768,deny)
> project.max-sem-ids=(priv,4096,deny)
> project.max-msg-ids=(priv,4096,deny)
>
> Additionally, if you are running PostgreSQL inside a zone, you may need
> to raise the zone resource usage limits as well. See "Chapter2:
> Projects and Tasks" in the Solaris 10 System Administrator's Guide for
> more information on projects and prctl.
>
> ================
>
> (and no, there's no reusable link to the solaris docs)
>
> --
> -- Josh Berkus
> PostgreSQL Experts Inc.
> http://www.pgexperts.com
>
> --
> Sent via pgsql-docs mailing list ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-docs
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
view thread (12+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Change to kernel-resources
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox