diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 22 | ||||
| -rw-r--r-- | doc/src/sgml/runtime.sgml | 38 |
2 files changed, 56 insertions, 4 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index d8ec4f9f658..f938a27bb91 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1,6 +1,6 @@ <!-- Documentation of the system catalogs, directed toward PostgreSQL developers - $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.110 2005/07/31 17:19:16 tgl Exp $ + $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.111 2005/08/11 21:11:41 tgl Exp $ --> <chapter id="catalogs"> @@ -1197,6 +1197,20 @@ <entry>Multiplier for reltuples to add to <structfield>anl_base_thresh</></entry> </row> + + <row> + <entry><structfield>vac_cost_delay</structfield></entry> + <entry><type>integer</type></entry> + <entry></entry> + <entry>Custom <varname>vacuum_cost_delay</> parameter</entry> + </row> + + <row> + <entry><structfield>vac_cost_limit</structfield></entry> + <entry><type>integer</type></entry> + <entry></entry> + <entry>Custom <varname>vacuum_cost_limit</> parameter</entry> + </row> </tbody> </tgroup> </table> @@ -1217,7 +1231,11 @@ <para> Any of the numerical fields can contain <literal>-1</> (or indeed any negative value) to indicate that the system-wide default should - be used for this particular value. + be used for this particular value. Observe that the + <structfield>vac_cost_delay</> variable inherits its default value from the + <varname>autovacuum_vacuum_cost_delay</> configuration parameter, + or from <varname>vacuum_cost_delay</> if the former is set to a negative + value. The same applies to <structfield>vac_cost_limit</>. </para> </sect1> diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 87a97639632..060cd91ea16 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.343 2005/08/09 05:01:10 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.344 2005/08/11 21:11:42 tgl Exp $ --> <chapter Id="runtime"> @@ -3296,7 +3296,7 @@ SELECT * FROM parent WHERE key = 2400; <para> If on, collected statistics are zeroed out whenever the server is restarted. If off, statistics are accumulated across server - restarts. The default is <literal>on</>. This option can only + restarts. The default is <literal>off</>. This option can only be set at server start. </para> </listitem> @@ -3424,6 +3424,40 @@ SELECT * FROM parent WHERE key = 2400; </listitem> </varlistentry> + <varlistentry id="guc-autovacuum-vacuum-cost-delay" xreflabel="autovacuum_vacuum_cost_delay"> + <term><varname>autovacuum_vacuum_cost_delay</varname> (<type>integer</type>)</term> + <indexterm> + <primary><varname>autovacuum_vacuum_cost_delay</> configuration parameter</primary> + </indexterm> + <listitem> + <para> + Specifies the cost delay value that will be used in automatic + <command>VACUUM</> operations. If -1 is specified (which is the + default), the regular + <xref linkend="guc-vacuum-cost-delay"> value will be used. + This setting can be overridden for individual tables by entries in + <structname>pg_autovacuum</>. + </para> + </listitem> + </varlistentry> + + <varlistentry id="guc-autovacuum-vacuum-cost-limit" xreflabel="autovacuum_vacuum_cost_limit"> + <term><varname>autovacuum_vacuum_cost_limit</varname> (<type>integer</type>)</term> + <indexterm> + <primary><varname>autovacuum_vacuum_cost_limit</> configuration parameter</primary> + </indexterm> + <listitem> + <para> + Specifies the cost limit value that will be used in automatic + <command>VACUUM</> operations. If -1 is specified (which is the + default), the regular + <xref linkend="guc-vacuum-cost-limit"> value will be used. + This setting can be overridden for individual tables by entries in + <structname>pg_autovacuum</>. + </para> + </listitem> + </varlistentry> + </variablelist> </sect2> |