Re: Change to kernel-resources

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Change to kernel-resources
Date: 2011-02-05 03:07:01
Message-ID: 201102050307.p15371J06946@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs


Having received no replies to my request for an updated doc, I am going
to let the issue drop.

---------------------------------------------------------------------------

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

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2011-02-05 15:55:05 Re: Change to documentation headers
Previous Message Bruce Momjian 2011-02-05 01:34:38 Re: [GENERAL] Gripe: bytea_output default => data corruption