diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 139 | ||||
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 9 |
2 files changed, 147 insertions, 1 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 36a2a5ce431..43b1a132a2c 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -2006,6 +2006,145 @@ include_dir 'conf.d' </listitem> </varlistentry> + <varlistentry id="guc-commit-timestamp-buffers" xreflabel="commit_timestamp_buffers"> + <term><varname>commit_timestamp_buffers</varname> (<type>integer</type>) + <indexterm> + <primary><varname>commit_timestamp_buffers</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Specifies the amount of memory to use to cache the contents of + <literal>pg_commit_ts</literal> (see + <xref linkend="pgdata-contents-table"/>). + If this value is specified without units, it is taken as blocks, + that is <symbol>BLCKSZ</symbol> bytes, typically 8kB. + The default value is <literal>0</literal>, which requests + <varname>shared_buffers</varname>/512 up to 1024 blocks, + but not fewer than 16 blocks. + This parameter can only be set at server start. + </para> + </listitem> + </varlistentry> + + <varlistentry id="guc-multixact-member-buffers" xreflabel="multixact_member_buffers"> + <term><varname>multixact_member_buffers</varname> (<type>integer</type>) + <indexterm> + <primary><varname>multixact_member_buffers</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Specifies the amount of shared memory to use to cache the contents + of <literal>pg_multixact/members</literal> (see + <xref linkend="pgdata-contents-table"/>). + If this value is specified without units, it is taken as blocks, + that is <symbol>BLCKSZ</symbol> bytes, typically 8kB. + The default value is <literal>32</literal>. + This parameter can only be set at server start. + </para> + </listitem> + </varlistentry> + + <varlistentry id="guc-multixact-offset-buffers" xreflabel="multixact_offset_buffers"> + <term><varname>multixact_offset_buffers</varname> (<type>integer</type>) + <indexterm> + <primary><varname>multixact_offset_buffers</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Specifies the amount of shared memory to use to cache the contents + of <literal>pg_multixact/offsets</literal> (see + <xref linkend="pgdata-contents-table"/>). + If this value is specified without units, it is taken as blocks, + that is <symbol>BLCKSZ</symbol> bytes, typically 8kB. + The default value is <literal>16</literal>. + This parameter can only be set at server start. + </para> + </listitem> + </varlistentry> + + <varlistentry id="guc-notify-buffers" xreflabel="notify_buffers"> + <term><varname>notify_buffers</varname> (<type>integer</type>) + <indexterm> + <primary><varname>notify_buffers</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Specifies the amount of shared memory to use to cache the contents + of <literal>pg_notify</literal> (see + <xref linkend="pgdata-contents-table"/>). + If this value is specified without units, it is taken as blocks, + that is <symbol>BLCKSZ</symbol> bytes, typically 8kB. + The default value is <literal>16</literal>. + This parameter can only be set at server start. + </para> + </listitem> + </varlistentry> + + <varlistentry id="guc-serializable-buffers" xreflabel="serializable_buffers"> + <term><varname>serializable_buffers</varname> (<type>integer</type>) + <indexterm> + <primary><varname>serializable_buffers</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Specifies the amount of shared memory to use to cache the contents + of <literal>pg_serial</literal> (see + <xref linkend="pgdata-contents-table"/>). + If this value is specified without units, it is taken as blocks, + that is <symbol>BLCKSZ</symbol> bytes, typically 8kB. + The default value is <literal>32</literal>. + This parameter can only be set at server start. + </para> + </listitem> + </varlistentry> + + <varlistentry id="guc-subtransaction-buffers" xreflabel="subtransaction_buffers"> + <term><varname>subtransaction_buffers</varname> (<type>integer</type>) + <indexterm> + <primary><varname>subtransaction_buffers</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Specifies the amount of shared memory to use to cache the contents + of <literal>pg_subtrans</literal> (see + <xref linkend="pgdata-contents-table"/>). + If this value is specified without units, it is taken as blocks, + that is <symbol>BLCKSZ</symbol> bytes, typically 8kB. + The default value is <literal>0</literal>, which requests + <varname>shared_buffers</varname>/512 up to 1024 blocks, + but not fewer than 16 blocks. + This parameter can only be set at server start. + </para> + </listitem> + </varlistentry> + + <varlistentry id="guc-transaction-buffers" xreflabel="transaction_buffers"> + <term><varname>transaction_buffers</varname> (<type>integer</type>) + <indexterm> + <primary><varname>transaction_buffers</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Specifies the amount of shared memory to use to cache the contents + of <literal>pg_xact</literal> (see + <xref linkend="pgdata-contents-table"/>). + If this value is specified without units, it is taken as blocks, + that is <symbol>BLCKSZ</symbol> bytes, typically 8kB. + The default value is <literal>0</literal>, which requests + <varname>shared_buffers</varname>/512 up to 1024 blocks, + but not fewer than 16 blocks. + This parameter can only be set at server start. + </para> + </listitem> + </varlistentry> + <varlistentry id="guc-max-stack-depth" xreflabel="max_stack_depth"> <term><varname>max_stack_depth</varname> (<type>integer</type>) <indexterm> diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 9d73d8c1bbe..4b8b38b70ef 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -4482,12 +4482,19 @@ description | Waiting for a newly initialized WAL file to reach durable storage <para> <productname>PostgreSQL</productname> accesses certain on-disk information - via <firstterm>SLRU</firstterm> (simple least-recently-used) caches. + via <literal>SLRU</literal> (<firstterm>simple least-recently-used</firstterm>) + caches. The <structname>pg_stat_slru</structname> view will contain one row for each tracked SLRU cache, showing statistics about access to cached pages. </para> + <para> + For each <literal>SLRU</literal> cache that's part of the core server, + there is a configuration parameter that controls its size, with the suffix + <literal>_buffers</literal> appended. + </para> + <table id="pg-stat-slru-view" xreflabel="pg_stat_slru"> <title><structname>pg_stat_slru</structname> View</title> <tgroup cols="1"> |