pg.ddx.io pgsql-admin@postgresql.org mailing list archive help / color / mirror / Atom feed From: Bruce Momjian <bruce@momjian.us>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: valiouk@yahoo.co.uk, pgsql-docs@postgresql.org, dx k9 <bitsandbytes88@hotmail.com>
Subject: Re: [ADMIN] shared_buffers and shmmax
Date: Thu, 18 Dec 2008 12:07:20 -0500 (EST)
Message-ID: <200812181707.mBIH7KA01987@momjian.us> (raw )
In-Reply-To: <20081217152038.GB4453@alvh.no-ip.org >
Alvaro Herrera wrote:
> Bruce Momjian wrote:
>
> > I decided I didn't like what I did either; updated version with new
> > headings and shorter descriptions:
> >
> > http://momjian.us/tmp/pgsql/kernel-resources.html
>
> This version seems good to me, except please put back the B to the end
> of "770 k".
Patch applied with "B" re-added, though I would like to mention again
that it is inconsistent because we don't mention bytes in any other row
in that column.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Attachments:
/rtmp/diff (text/x-diff, 3.8K) download
Index: runtime.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v
retrieving revision 1.423
retrieving revision 1.424
diff -c -c -r1.423 -r1.424
*** runtime.sgml 16 Dec 2008 19:30:43 -0000 1.423
--- runtime.sgml 18 Dec 2008 17:03:09 -0000 1.424
***************
*** 1,4 ****
! <!-- $PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.423 2008/12/16 19:30:43 alvherre Exp $ -->
<chapter Id="runtime">
<title>Operating System Environment</title>
--- 1,4 ----
! <!-- $PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.424 2008/12/18 17:03:09 momjian Exp $ -->
<chapter Id="runtime">
<title>Operating System Environment</title>
***************
*** 1080,1120 ****
<table id="shared-memory-parameters">
! <title>Configuration parameters affecting
! <productname>PostgreSQL</productname>'s shared memory usage</>
<tgroup cols="2">
<thead>
<row>
! <entry>Name</>
! <entry>Approximate multiplier (bytes per increment) as of 8.3</>
</row>
</thead>
<tbody>
<row>
! <entry><xref linkend="guc-max-connections"></>
! <entry>1800 + 270 * <xref linkend="guc-max-locks-per-transaction"></entry>
</row>
<row>
! <entry><xref linkend="guc-autovacuum-max-workers"></>
! <entry>1800 + 270 * <xref linkend="guc-max-locks-per-transaction"></entry>
</row>
<row>
! <entry><xref linkend="guc-max-prepared-transactions"></>
! <entry>770 + 270 * <xref linkend="guc-max-locks-per-transaction"></entry>
</row>
<row>
! <entry><xref linkend="guc-shared-buffers"></>
! <entry>8400 (assuming 8 kB <symbol>BLCKSZ</>)</entry>
</row>
<row>
! <entry><xref linkend="guc-wal-buffers"></>
! <entry>8200 (assuming 8 kB <symbol>XLOG_BLCKSZ</>)</entry>
</row>
<row>
--- 1080,1124 ----
<table id="shared-memory-parameters">
! <title><productname>PostgreSQL</productname> shared memory usage</>
<tgroup cols="2">
<thead>
<row>
! <entry>Usage</>
! <entry>Approximate shared memory bytes required (as of 8.3)</>
</row>
</thead>
<tbody>
<row>
! <entry>Connections</>
! <entry>(1800 + 270 * <xref
! linkend="guc-max-locks-per-transaction">) * <xref
! linkend="guc-max-connections"></entry>
</row>
<row>
! <entry>Autovacuum workers</>
! <entry>(1800 + 270 * <xref
! linkend="guc-max-locks-per-transaction">) * <xref
! linkend="guc-autovacuum-max-workers"></entry>
</row>
<row>
! <entry>Prepared transactions</>
! <entry>(770 + 270 * <xref
! linkend="guc-max-locks-per-transaction">) * <xref linkend="guc-max-prepared-transactions"></entry>
</row>
<row>
! <entry>Shared disk buffers</>
! <entry>(<xref linkend="guc-block-size"> + 208) * <xref linkend="guc-shared-buffers"></entry>
</row>
<row>
! <entry>WAL buffers</>
! <entry>(<xref linkend="guc-wal-block-size"> + 8) * <xref linkend="guc-wal-buffers"></entry>
</row>
<row>
***************
*** 1125,1142 ****
</tgroup>
</table>
- <note>
- <para>
- The multipliers for <varname>shared_buffers</> and
- <varname>wal_buffers</> should be the number of buffers, not the
- amount in bytes. To find out the number of shared or wal buffers, divide
- the amount in bytes by <xref linkend="guc-block-size"> and
- <xref linkend="guc-wal-block-size">, respectively.
- </para>
- </note>
</sect2>
-
<sect2>
<title>Resource Limits</title>
--- 1129,1136 ----
view thread (28+ messages) latest in thread
Message-ID: <200812181707.mBIH7KA01987@momjian.us>
Permalink: ../200812181707.mBIH7KA01987@momjian.us/
Also on: postgresql.org/message-id/200812181707.mBIH7KA01987@momjian.us
copy link · copy postgr.es · copy git am
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: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, alvherre@commandprompt.com, tgl@sss.pgh.pa.us, bitsandbytes88@hotmail.com
Subject: Re: [ADMIN] shared_buffers and shmmax
In-Reply-To: <200812181707.mBIH7KA01987@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox